After doing a HD data transfer, all my spreadsheets open with this
message, followed by a series of .xls file Excel couldn't find
(apparently). File reads OK, and I can save changes, but clicking
through this series of warnings on every spreadsheet is getting

I have an excel file with email addresses. Periodically I need to send all
of these these people an email, so I need one mail where the 'To' field is
filled with all the email addresses. What is the best way to automate this?
Can I perhaps make a macro in Excel that opens Outlook ...

I have a 40 year Capital Item Replacement Program.
This formula is in Row 4 , Columns B thru AP
=if(ISNA(VLOOKUP(H2,Sheet7!$C$19:$C$D28,2,False)),0,VLOOKUP(H2,Sheet7!$C$19:$D$28,2,False))
Row 2, Column B thru AP =2002 to 2042. Therefore B2=2002 & H2 = 2008 etc.

I receive a number of tab delimited text files which I need to convert
to Excel spreadsheets. Each file is similar in format: the first line
contains only one entry which is to become the "title" of the report.
The second line contains column headings (always the same) and the

I have a formula =(a5-a4)*24 I need it so only when the value is greater
then 4 it will subtract 0.5 if the value is 4 or less it wont subtract
anything.
I should know this one but I cant get it to work for me tonight.

Does anyone know why I get an error   #NAME?    from this :
activecell.formulaR1C1 = "= VLOOKUP(RC[-1],Sheet1!C[-1]:C[75],hdr,0)"
hdr has been DIM as an integer. When running the value of hdr=33
If I put 33 in place of hdr qne run the macro,  the lookup runs fine?

I am trying to make leader dots between cells as seamless as possible and
right now there is a gap showing up.
The custom format I used was @*. and *.# and they worked fine, now I would
just like to eliminate the gap between the two and I'll be set.

Any Ideas???
How would you capture the value the active column in a variable?
=column()    will give the value of the active column
How would I use a variable to capture that value.      val = column()   ????

i am new at this, how do i add and subtract and get the answer.

I'd like to be able to have the first two rows at the top of my page repeat
as the first two rows at the top of every page of a long document. I can't
quite figure out how to do this. It would kind of be like a heading at the
top of each page -- but I don't want to use the header ...

I would like to replace 1800 product numbers and put my numbers onto them.
can i do this all at one time or do i have to relace the numbers 1 at a time.
Thanks for any help you can give me.

I just noticed that a DSUM function I was using is not working
properly because the criteria includes an empty cell and the function
is not picking up an empty cell as meaning that the criterion is an
empty cell.

I've set up a sheet that works great _except_ if B1 has a value in it but B2
doesn't.  I've set up conditional formatting.
When B1 is empty, no colour or font attributes in cells B3 to B14.  Good.
If B1 does have a value in it, the cell colour and font attributes in B3 to

If I find and replace (-) every cell that has (-) will convert back to their
original color which I spent hours re-doing. Anyone know anything about
this?

How can I ensure that the format used in a PC created worksheet remains the
same when opened in Excel on a MAC?