How to select an unspecified range in a worksheet

[cassidybklyn]

Hi everybody,
I working with vb6 and I currenlty have a spreadsheet with data up to the range of (A2:G143) that requires sorting. But I do not want to hard code this range because the range of data in the spreadsheet may change at anytime (either more data or less data). How can I tell it to choose the appropriate range at any given time based on the amount of data in the spreadsheet?

For example:
range(A2:??????)
Thanks.
Cassidy

 

[SkipVought]

Hi,

SheetObject.[A2].CurrentRegion.Sort..........

Skip,

_[red][/red]

 

[PHV]

You may try to sort the range returnrned by Range("A2").CurrentRegion

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cassidybklyn]

Thanks guys. I'll try it out on monday in the office.
Enjoy your weekend.
Cassidy.