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

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



---
Regards,
Norman



"Alvin Hansen" wrote in message
...
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

Sheets("perioder").Calculate

--
Regards,
Tom Ogilvy


"Alvin Hansen" wrote in message
...
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

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



---
Regards,
Norman



"Alvin Hansen" wrote in message
...
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