Thread
:
Copy Row Above, with a Twist Q
View Single Post
#
6
Posted to microsoft.public.excel.programming
Claus Busch
external usenet poster
Posts: 3,872
Copy Row Above, with a Twist Q
Hi,
Am Thu, 5 Jan 2017 01:04:02 -0800 (PST) schrieb
:
Claus, thats it, works exactly how I want, one small thing, the very last row of Data doesn't copy down, so the code stops at the last row, but that last row needs to be copied down, then stop
change that row
Set myRng = .Range("A2:A" & LRow)
to
Set myRng = .Range("A2:A" & LRow + 1)
Regards
Claus B.
--
Windows10
Office 2016
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch