nirvehex
09-24-2014, 01:21 PM
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!
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!