how to get a range

B

Bruno Storz

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
 
S

Stephan Kassanke

Bruno Storz said:
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
Click to expand...

Hi Bruno,

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

cheers,
Stephan
 
Top