Do you know how I would enter a range reference that would subtract col b
from col a (I am in col C) but the rows would change each time I rerun the
reporrt. I'm trying to write a macro to automate everything and I'm ok if my
data is static...

I'm feeling very lost

Thanks

"T. Valko" wrote:

See if this helps:

http://contextures.com/xlNames01.html#Dynamic

Biff

"SD" wrote in message
...
Hi there,

I am trying to reference a range that changes as each day goes by.
Currently its A2:A500....Tomorrow it will be A2:A501 etc etc.

So I am trying something like this but its not working
A2:Count(A2:A10000).
I think i might need to use offset but not sure.

Thanks a lot

SD