I am comfortable working with Dynamic Ranges that expand and contract
automatically, based on =offset()

Example he
http://www.ozgrid.com/Excel/DynamicRanges.htm


I am trying to figure out another way to do this. I am working with a model
that someone else designed. He is no longer with the company so I cant ask
him how he crated this dynamic offset, but it works on the same principal as
the =offset() function mentioned above. All I can see is a blue border
around the list of data that is being offset from. Also, there is a small
blue asterisks in the lower left hand corner of the list€¦this seems to
indicate the last row (which is blank) of this otherwise invisible offset
feature. Can anyone shed some light on this topic for me?

Regards,
Ryan---


--
RyGuy