I can't seem to figure out the proper "Offset" syntax. I keep getting a syntax error.
I want to represent the equivalent of the following as a variable range using Offset:
Range("G10:R10").Select
Selection.Copy
I currently have:
Range(Cells(StringLocRow, CopyCol), Cells(StringLocRow, CopyCol.Offset(0, 11))).Select
Selection.Copy
Where StringLocRow = the active row (10), and CopyCol = G
Also, once the proper syntax is developed, I want to copy the values and paste the range of values on a different worksheet - preferably by selecting a single cell on the new worksheet and filling in the range like I would do it manually in Excel.
Any assistance would be greatly appreciated. Thanks in advance.
Bookmarks