View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] newpizzaco@gmail.com is offline
external usenet poster
 
Posts: 8
Default Copy Row Above, with a Twist Q

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

I'm assuming this line needs adjustment LRow = .Cells(.Rows.Count, 1).End(xlUp).Row?