How to make a Macro Iterate

E

Elisha

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
 
B

Bob Phillips

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 said:
Hello,

I'm using Excel 2002 and I want to create a macro that iterates through
Click to expand...
worksheets using the same cell ranges to generate identically formatted
graphs of the data in each sheet.
 
Top