LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Adam1 Chicago
 
Posts: n/a
Default Repeating VBA operations

I have several hundred lines of code that look like:

Sheets("First").Select
[LOTS OF CODE HERE]
End of code

If I want to repeat all of the same steps on two other sheets, do I have to
copy and paste the code twice under the names of the two different sheets or
is there a command I can use to repeat all of the code on different sheets?

Thanks

(P.S. I am a total novice, so the easier the solution the better.)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
repeating formulas by the same row or colum increment as the last. Formulas Excel Discussion (Misc queries) 0 February 24th 05 04:55 AM
repeating formulas by the same row or colum increment as the last. Formulas Excel Discussion (Misc queries) 0 February 24th 05 04:51 AM
Header - stop repeating on every page! sararose27 Excel Discussion (Misc queries) 2 February 17th 05 10:41 PM
reference a repeating cell in a formula Tafe Riller Excel Worksheet Functions 1 February 17th 05 03:20 PM
Repeating formula in Excel RescueEMT72 Excel Discussion (Misc queries) 8 November 28th 04 03:37 AM


All times are GMT +1. The time now is 09:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"