Update a sheet

[Guest]

Hi
In excel i can say that excel not shall calculate all sheets
i set this to manuel.
But is there not a way i can update one specific sheet
from a vba form?

I have try with

Sheets("perioder").Update

but here i get a error

Best regards alvin

 

[Norman Jones]

Hi Alvin,

From VBA Help on Calculate:

All open workbooks Application.Calculate (or just Calculate)
A specific worksheet Worksheets(1).Calculate
A specified range Worksheets(1).Rows(2).Calculate

 

[Tom Ogilvy]

Sheets("perioder").Calculate

 

[Guest]

Its working
Thanks
alvin


"Norman Jones" skrev:

Hi Alvin,

From VBA Help on Calculate:

All open workbooks Application.Calculate (or just Calculate)
A specific worksheet Worksheets(1).Calculate
A specified range Worksheets(1).Rows(2).Calculate