I cannot get this to run the [ELK] macro when these 3 conditions are
met.  It worked until I added the OR statement.   I would really like
it to check if the reference cells have numbers in them. Then if NOT
run the ELK macro.       If Sheet1.Range("b10").Value <> "" Or

Is this possible?  User has a workbook with multiple sheets already set up.  
They want to copy the header and footer from one of the sheets to all other
sheets.
I'd like to set it up so that it prompts them for the sheet with the h/f to

I am new to EXCEL 2007 and, at the bottom left of my spreadsheet, it says
Ready, then Calculate.  In EXCEL 2003, this would suggest that the
spreadsheet is on manual recalc (or calc except data tables, maybe).  But
this spreadsheet is on automatic, and I have hit F9 a few times.

I need to transfer the data ( rows ) from one sheet to different
workbooks based on a citeria.
Example -
Column B may contain B01,B02,B03......

How can I copy selected sheets and move them to a new book as values only?
Thanks!

I need a macro to delete information in cells (A2:G2), and change the value
of a check box to false. The check box is linked to cell (E2) and the value
should change to false. The check box was created useing the forms tool box.
Thanks!

Hello.  I have a situation in which I seek the assistance from the newsgroup.
There is an excel 2003 spreadsheet that is populated with stock information
thru a web service.  This information is updated every few seconds.  This
works fine.  An RTD addin was developed that pulls ...

I want to create a UDF that when placed in a cell will create a validation
for that cell.  The challenge is how to keep the UDF in the cell's formula
when the user makes a selection from the validation's drop-down list?
So for example, I might have a UDF

How can I replace part of the ThisWorkBook.Path property?  Lucking,
the 10 characters I need to replace the END of the path (not in the
middle).  To be even more specific:
THIS:   \\server\drive\folder\folder\folder\DRAFT Recs

This is driving me crazy!
I have a bunch of constants and Private Enums declared at the top of my
regular module.
e.g.

I am trying to ise a command button to save a single worksheet from a
workbook to export to outlook and mail it.  So far I have the following which
works fine but mails the whole workbook.  My code is not good so details are
appreciated.

Does anyone know of a way to find the path to the executable that opens a
particular file, such that if I give the path to a file (or just the file
type extension) it will return the path to the executable that opens that
file.  For example if I give the path to "C:\Documents and ...

I am not understanding something of Chips function.
If I run a macro with "MsgBox Age(12 / 3 / 61, 1 / 31 / 8)" I get "0 years 0
months 0 days" returned?  Obviously there is at least 46 years here.  What do
I have formatted wrong?

We are attempting to print all tabs of an Excel workbook to single page TIFF
files.  
Does anyone know of any utilities that work well to convert all tabs of an
Excel workbook to single page TIFF files?

I'm looking for a macro to delete all values in a worksheet less than 10.  
Can anybody help me with this?!?!  THANKS!