Would like a macro to copy a cell down a variable number of rows

macropod · #6 03-25-2016, 08:18 PM

Quote:

Originally Posted by Rod_Bowyer

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail merge at large table with variable number of rows	blar	Mail Merge	1	10-19-2015 03:04 PM
How to find number of coma and then add that number of rows in word using macro?	PRA007	Word VBA	7	05-27-2015 10:45 PM
Copy Rows down with value from another Cell	burlinghamla	Excel	1	01-14-2015 06:26 AM
Creating a table for a variable number of rows	OllieOnline	Mail Merge	1	03-27-2013 02:48 PM
Using macro to add variable number of rows to a protected word table	Julia	Word Tables	1	01-09-2013 06:04 AM