PDA

View Full Version : Solved: Range Reference Quickie



jmenche
02-08-2007, 07:51 AM
Howdy,

I am using a LastRow variable and I want to define a range as "F4:F&LastRow" but I am obviously not getting the syntax right. Can someone help me out??

:beerchug:

Charlize
02-08-2007, 08:02 AM
range("F4:F" & LastRow)

Bob Phillips
02-08-2007, 08:05 AM
Set rng = Range("F4").Resize(LastRow-3)

jmenche
02-08-2007, 09:15 AM
Thanks all!