dpaton05
Well-known Member
- Joined
- Aug 14, 2018
- Messages
- 2,375
- Office Version
- 365
- 2016
- Platform
- Windows
I have some code to paste a range below the current range. I want it to find the bottom of the document and then create a new page after it to paste the range onto. There might be an image put in at the bottom of the document . At the moment, the code I have to insert the range is:
This code works if I just want a fixed distance below the bottom of the bottom range, but this can cause the image to be split over multiple pages and I need the image to be on one page and have each range start on a new page.
Can someone help me with this code please?
VBA Code:
With WS
.Range("A8:V32").Copy .Range("A" & Rows.Count).End(xlUp).Offset(10, 0)
End With
This code works if I just want a fixed distance below the bottom of the bottom range, but this can cause the image to be split over multiple pages and I need the image to be on one page and have each range start on a new page.
Can someone help me with this code please?