Pasteing code to a changing number of rows

[David Van Elswyk]

I have an .xlt and have to columns at the end with formulas in it, i want to
make it only paste in the cells where there is data in the same row insted
of pasting it down the whole column. Any ideas thanks

David

 

[Bernie Deitrick]

David,

Filter your sheet to only show filled cells (non blanks), then select your
column and use Edit | Go To.... Special Visible cells only... Then do
your paste.

HTH,
Bernie
MS Excel MVP