Prev: Non-matching cells
Next: Limit due to selected cells
From: Jacob Skaria on 6 May 2010 09:21
OK. Try the below

Sub Macro()
Dim lngRow As Long

lngRow = Cells(Rows.Count, "Q").End(xlUp).Row

Range("R4:R" & lngRow) = Range("R4:R" & lngRow).Value
Range("U4:U" & lngRow) = Range("U4:U" & lngRow).Value

End Sub


--
Jacob (MVP - Excel)


"Max" wrote:

> Thanks, but I'm not sure how to adapt those lines to suit the desired
> "freeze" extent, ie only from row 4 down to the last row of data in col Q,
> not the entire col. Grateful if you could take a moment to piece it together
From: Max on 6 May 2010 09:31
Many thanks, Jacob. Works great, exactly as desired.
First  |  Prev  | 
Pages: 1 2
Prev: Non-matching cells
Next: Limit due to selected cells