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