Range description

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
 
H

Harald Staff

Hi Kenny

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

HTH. Best wishes Harald
 
Top