Searching in excel
What is the best program or way to search in excel? (other than using
simple find) I'd like to be able to see all of the results in one area
and then click on to jump to it. Is there anything out there that has

I'm VBA dumb so please bear with me.  I have a macro that inserts a row at the selection and then I want it to copy the cell below the selection and paste into the new row's cell.  Here's what's in the macro now
   Selection.EntireRow.Inser
   Range("D23").Selec
   Selection ...

In one row I have:
  A              B                 C                   D                 E
F                   G
Cust#     Address 1    Address 2    Address3    Address 4    Address5

I know this is not the forum for word stuffs, but i'm just looking fo
a good site like this for word.
Looking for info on how to autorun code when document is opened.
cheer

I have an excel file with macros in it and activated.
The VBA-Code is hidden with password protection.
Sometimes when I close that file the main window gets closed but the
password dialog box for the vba code pops up. I have then to click

I want to change the format of date data for writing out to a file,
without changing the original data.  How can I create a temporary copy
of the current cell to do this?  I have tried a couple of things but
they always reference the original cell.  

How do I format cell allowing only number entry and give message fo
retry?
Thanks in advance for your help
--

Hi I'm on Microsoft Spreadsheet and I was wondering how to paste a
image into the sheet.  I tried copying it, but both paste and past
special were greyed.  Any ideas??  Thanks
--

Excel 2002
I'm using Data Validation for the 1st time and I'm wondering if this feature
is capable of preventing users from deleting (with the keyboard Delete key)
a default value in a cell (8) unless they replace it with a number (decimal

Is there a function that will let me calculate the rank of a word durin
data entry the same way the function rank(#) works on numbers?
Name      Rank
Zander     5

Hi, I am importing a list into Excel 97, the list contains tim
durations ex 1:33 and :20 and :10.
I want to add thes up  (in the above example the answer would be  2:00
but it is not working when I use the sum function. I have looked a

BlankHow can I prevent the Header Row from scrolling away? I like it to
always stay on top of my displayed work sheet as I scroll down on it.
I know it is a way, I just can't find it.
Anders

I really need some help !!!!
I've a big s/sheet - some 40mb in size (lots of formulae, data etc)
that up until a few weeks back has been working fine on my laptop
(1.2ghz).  Then all has gone down hill.  The s/sheet is taking

How can I create a named range for A1:A500 that never grows/shrinks
after cutting and pasting, etc.? I.e, I want the named range to always
refer to A1:A500.

I'm trying to do a basic workshift for adding up my timesheets for work. I
work 07:00 to 14:00 on the morning shift, 14:00 to 21:00 on the afternoon
shift and 21:00 to 07:00 on nights. Then I have to add 20% for the shift
premium. In column A I've put the start time, Column B the ...