Thread: [Solved] Would like a macro to copy a cell down a variable number of rows
View Single Post
 
Old 03-25-2016, 08:18 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Quote:
Originally Posted by Rod_Bowyer View Post
The Macro which Paul gave me works wonderfully but carries on down to the end of the formatting (in the larger spreadsheet I have it set up as a table) and when the number of records changes each time the formatting stays the same for some reason or another and I cannot delete it (if any of that makes sense to you).
Your previous post didn't include such detail, so it wasn't allowed for. To handle that, change:
.Cells.SpecialCells(xlCellTypeLastCell).Row
to:
.Range("B" & .Cells.SpecialCells(xlCellTypeLastCell).Row).End(x lUp).Row
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote