Pasteing code to a changing number of rows

  • Thread starter Thread starter David Van Elswyk
  • Start date Start date
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
 
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
 
Back
Top