If I understand the request why not just use the single line of code
![]()
Sheet1.Range("A1").CurrentRegion.Offset(1, 0).Copy Destination:=Sheet2.Range("A2")
If I understand the request why not just use the single line of code
![]()
Sheet1.Range("A1").CurrentRegion.Offset(1, 0).Copy Destination:=Sheet2.Range("A2")
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks