Range description

  • Thread starter Thread starter N E Body
  • Start date Start date
N

N E Body

Hello everyone

At present I am using

Range("A4:A3000")

How can I say Range("A4:A{last non empty cell}")

I can locate the cell with Range("A65536").End(xlUp) but how do you write
this as a range reference?

Kenny
 
Hi Kenny

Dim R As Range
Set R = Range(Range("A4"), Range("A65536").End(xlUp))

HTH. Best wishes Harald
 
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

VBA set thick borders around non empty cells in range 0
Import multiple workbooks to current workbook in specified row number 0
Copy user selected range from all open workbooks 2
Populating a range of empty cells with usernames 4
Sum a variable length column 1
UnSelect the copied to range after copy... 4
Post my named ranges in column A 10
Variable SUM range 16

Back
Top