Calculate all reports(sheets) in a workbook?

**stevebriz** · 08-30-2007, 05:02 PM

Ok.the problem is you do not have a defined range for "values" in any of you sheets .
Eg: select the range of values on each sheet and then go insert>Name> define and then give the name the range eg:"values"

I see in your code the defined range name "Values" is being asked for on different sheets.
you need different names for different ranges.

Once you do this you macro should run...but I cannot be sure it if will do everything or any of want you want....as I am noce clear on excatly the steps you want done in maniuplating /calculating the sheets.

**AlmostAGeek** · 08-30-2007, 07:59 PM

I understand what you are saying concerning the Named ranges. I use them in alot of my formulas. I will try and re-write this code and hopefully make it work. I think it would make more sense to anyone if I were able to post all of the pieces to the workbook.

Why would you name a range rather than just tell it to run all of the formulas on the sheet? Is there a "cheat-sheet" or glossary of terms used in writing code?

I am anxious to give it a try and see what I can do. It may take me a day or two but I will post back with any successes or failures.

Thank you for all of your help.

Calculate all reports(sheets) in a workbook?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions