Thread: paste range to all sheets after specified sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J.W. Aldridge J.W. Aldridge is offline
external usenet poster
  
Posts: 425
Default paste range to all sheets after specified sheet
from sheet "templates"
copy range A1:f13
and paste all to each sheet after "templates"

then from sheet "templates"
copy range A14:f:45
then paste formats only to each sheet after "templates"
Reply With QuoteReply With Quote