Range description
 

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

Range description
 

Hi Kenny

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

HTH. Best wishes Harald

"N E Body" skrev i melding
...
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