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
|