Pasteing code to a changing number of rows

D

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
 
B

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
 
Top