How to make a Macro Iterate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Iterating through a ComboBox's values 6
Calculations not keeping up with macro 3
Iterating through a ComboBox's values 6
iterating through worksheets 7
Macro to iterate through rows in a worksheet (problem) 3
Data exchange between macro and spreadsheet 1
Running a Macro at every Solver Iteration 4
Iterate over irregular shaped range problem 3

Back
Top