Select Column with VBA and come up 3 rows from bottom

[nirvehex]

Hi I have a code:



Sheets("Recommendations").Select
Range("Q3").Select
Range(Selection, Selection.End(xlDown) - 3).Select
Selection.Copy
Sheets("Client Pre-Bid").Select
Range("Q2").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False


It's meant to select the 3rd row of column Q on the recommendations sheet, highlight all the way down, then come up 3 rows and copy, and paste special values starting in Q2 on the Client Pre-Bid sheet.

I keep getting a debug error because of the -3. Anyone know another way to write this?

Thank you!

[nirvehex]

Nevermind. Got it!



Range(Selection, Selection.End(xlDown).Offset(-3, 0)).Select