Range("Y1:Y" & LastRow & "&")

[LuisE]

What is the correct way to put the variable and the quotation after it?

Thanks in advance

 

[EagleOne]

Range("Y1:Y" & YourCell.Row)

 

[Peter T]

Range("Y1:Y" & LastRow)

quotation after it?

don't do that <g>

Regards,
Peter T