lastrow

[Shadow123]

Hi,

Im tinkering with some code i found, and the below mod i have made doesn't seem to work... (object error). I am trying to get it to be

Rng1 = Column O Cells 3 upto the last used cell in Col A. So for example if A is filled out to A200 the rng1 = range("o3200")

Can anyone tell me what im doing wrong?

   With Sh1
        Set Rng1 = .Range("o3:o") & .Range("a" & .Rows.Count).End(xlUp).Row
    End With

 

[VoG]

Try

With Sh1
    Set Rng1 = .Range("o3:o" & .Range("a" & .Rows.Count).End(xlUp).Row)
End With

 

[Shadow123]

that works fine... im on fire today lol a ")" this time lol