Calculate all reports(sheets) in a workbook?

This is my first attempt at posting code-I've read the instructions-hopefully I've done it right.

I am using the code below to allow a user to calculate all financial reports in a workbook. This came from a sample file and I thought I had adjusted it to fit my needs but I am getting error messages.

The sheets are labeled - Balance Sheet - Income Statement - Variance - Debt Service. It first hangs at the line that I have bolded in red below. None of the cell references in the code below have any formulas or information in them. Could they reference the end of each report?

If anyone could look at this and give me advise I would appreciate it.

Be gentle with me, I am making huge progress but am still learning. Most of it is thanks to people like all of you willing to share your expertise!!

Please Login or Register  to view this content.

Thank you for taking the time to help, any suggestions would be greatly appreciated......

It is the third line:

Range("Values").Select

I don't know if it will error out anywhere else.

I've scaled down the file tremendously - I hope it makes sense. I had trouble getting below the file size rule.

It would normally have five sheets but I think you get the idea.

Thanks for helping with this.

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.