Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make a Macro Iterate
Hello,
I'm using Excel 2002 and I want to create a macro that iterates through worksheets using the same cell ranges to generate identically formatted graphs of the data in each sheet. Is it possible to create such a Macro, and if so, how do I do it? Elisha |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make a Macro Iterate
For Each sh In Activeworkbook.Worksheets ' do you bit with sh.Range("A1:H10") say Next sh -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Elisha" wrote in message ... Hello, I'm using Excel 2002 and I want to create a macro that iterates through worksheets using the same cell ranges to generate identically formatted graphs of the data in each sheet. Is it possible to create such a Macro, and if so, how do I do it? Elisha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SOLVER does not iterate / work | Excel Discussion (Misc queries) | |||
Iterate Circular Reference | Excel Discussion (Misc queries) | |||
Iterate though all open spreadsheets | Excel Worksheet Functions | |||
VBA: How to iterate through each cell of one specific row | Excel Programming | |||
Iterate columns | Excel Programming |