horizonflame
Board Regular
- Joined
- Sep 27, 2018
- Messages
- 184
- Office Version
- 2013
Hi All,
I have found my formula for pasting a copied range to the next blank column, but need some help if the next blank column is the first column in the sheet. With my current formula it pastes to column B not A.
Many thanks![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I have found my formula for pasting a copied range to the next blank column, but need some help if the next blank column is the first column in the sheet. With my current formula it pastes to column B not A.
Sheets("DataRaw").Select
Application.Goto Reference:="R2C1:R7000C2,R2C7:R7000C7"
Selection.Copy
Sheets("DatesRaw").Range("A3").End(xlToLeft).Offset(0, 1).PasteSpecial xlValues
Application.CutCopyMode = False
Many thanks
Last edited: