Macro Range Selection From Top to end?

[Hyflex]

Currently I'm running simple:
Range("E4:AN25000").Select

But some days it might be from E4 to AN13392 or might be any number...

I want it only to select the right amount of rows but the thing is my excel page has multiple datasets so it might have a section of 50 rows, then 4 row gap, then 25 rows, then 4 row gap.... etc

Any help would be much appreciated.

 

[Gary McMaster]

Have a look at "CurrentRegion" in VBA help.

Gary

 

[Hyflex]

Have a look at "CurrentRegion" in VBA help.

Gary

Thanks Garry, I tried that this morning on my smaller spreadsheet and it keeps selecting to row 5000 and I have no data there... my smaller spreadsheet has like 500rows...

Any ideas?

Thanks
- Hyflex

 

[Weaver]

Would you like to share your code? For a start, you could probably do without the .select, for instance

Range("E4:AN25000").copy

copies the data in the range.

For a tighter selection, try:

Range("E4", Range("AN4").End(xlDown)).Select