"Mike Piazza" wrote in message
...
Thanks Dave,

When i use this line the macro will not include cells that have a formula
but do not reference other cells, such as = 120+56. for my purposes i
would
consider that a hard key cell.

Unfortunately, Excel does not.