how to get a range
 

Hi there,

I have a worksheet, starting at A1 we find a square range of data, which
will end somewhere.
How can I define the range without looping through each cell and check if
there are data in the cell?

Regards
Bruno

how to get a range
 

"Bruno Storz" schrieb im Newsbeitrag
...
Hi there,

I have a worksheet, starting at A1 we find a square range of data, which
will end somewhere.
How can I define the range without looping through each cell and check if
there are data in the cell?

Regards
Bruno



Hi Bruno,

Set myRange = Range("A1").CurrentRegion
myRange.Select

cheers,
Stephan

how to get a range
 

Danke! Bruno