Excel Dynamic range ?

I have seen this done somewhere..

Can i have a a range object that will grow with my expanding
list..


like myrange = range c3 to range EOF

??

That is all
Seahag

Select the top of your range

using: Range("A1").Select (or something)

Then this is like pressing end and the down arrow:

Selection.End(xlDown).Select

You may need to add to the front of these commands a qualifier.. this code was taken right out of excel vba..

try.. objExcel.ActiveDocument.Selection.End(xlDown).Select


-mcd

Cant get that to work..
Selection is a word.. thinggy..


I seen a real nifty way of doing it.. cant believe
I didn`t save it..
Thanks