how to get a range

  • Thread starter Thread starter Bruno Storz
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2013 Merge Data 2
UnSelect the copied to range after copy... 4
Arithmetic with Cell Dates 1
How to reference a cell from anther workbook without opening it 0
How to hide password? 1
Excel VBA 1
conditional format based on column statistics and loop over columns 1
Ron de Bruin - Merge cells from all worksheets 0

Back
Top