08-17-2009, 07:07 AM
|
|
Registered User
|
|
Join Date: 21 Jun 2009
Location: Sydney
MS Office Version:Excel 2003
Posts: 7
|
|
|
Re: Calculate Button
Quote:
Originally Posted by shua79
Code:
worksheet("Myworksheet").calculate
|
I got the following error:
"Compile error:
Sub or Function not defined"
This is the section of the code:
ActiveSheet.Paste
Worksheet("Expenses Input").Calculate
Application.Run "'BUDGET.xls'!GO_Staff"
EDIT
Would this do the same thing?
ActiveSheet.Calculate
|