View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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