Thread: run macro each sheet after and then copy range
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 run macro each sheet after and then copy range
Need to put the following together...


Select each sheet after "Data Sheet".
Run Macro1 on each sheet (this inputs a formula on each sheet).

Copy data range below from each sheet to "data sheet" starting at A10.

Range("A10:G10").Select
Range(Selection, Selection.End(xlDown)).Select

Reply With QuoteReply With Quote