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

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"David" wrote in message
...
How can i make the range as a dynamic range so it selects the entire sheet
that has value it.
Example
This month there are 572 rows, but I will add 200 rows this month, I do
not
want to select the range again. I was thinking if offset might work, but
do
not know the whole formula.

Help would be greatly appreciated.

David