JohnZ1156
Board Regular
- Joined
- Apr 10, 2021
- Messages
- 182
- Office Version
- 2021
- Platform
- Windows
I have a VBA Macro to paste a range to a specific cell, but now, I would like it to paste that range to the cell 4 rows below the last cell with data in column A.
Here's sort of what I'm talking about.
Before, I specified Cell A23. The last cell in column A with data is A19.
I know that I have to select a cell in column A way down at the bottom (A65536), then End(xlUp).Select
That takes me to Cell A19.
Then, how do I work an Offset(4,0) into this line of code where A23 is?
Sheets("PrintSOF").Range("A23").PasteSpecial xlPasteValues
Sheets("PrintSOF").Range("A23").PasteSpecial xlPasteFormats
Here's sort of what I'm talking about.
Before, I specified Cell A23. The last cell in column A with data is A19.
I know that I have to select a cell in column A way down at the bottom (A65536), then End(xlUp).Select
That takes me to Cell A19.
Then, how do I work an Offset(4,0) into this line of code where A23 is?
Sheets("PrintSOF").Range("A23").PasteSpecial xlPasteValues
Sheets("PrintSOF").Range("A23").PasteSpecial xlPasteFormats