Calculating an active cell range

[jmcmahon]

Hi,

I have a spreadsheet that calculates a range on sheet2 for me, but it also calculates sheet1. I just want sheet 2 calculated and the data table on sheet1 to not calculate.

Here is the code I'm using (I recorded a macro to get this)

right now Excel is set to manual calculate.

I've also had it set to automatic except for data tables
and still have the table on sheet1 calculating when I run this macro.


Sub Calculatesheet()
'
' Calculatesheet Macro
'
' Keyboard Shortcut: Ctrl+x
'
Range("b2:An32").Select
Calculate
End Sub


Thanks,

 

[James006]

Hi,

Have you tested ... without the Select ...:

[COLOR=#333333]Range("B2:AN32").[/COLOR][COLOR=#333333]Calculate[/COLOR]

HTH

 

[jmcmahon]

Hi,

Have you tested ... without the Select ...:

[COLOR=#333333]Range("B2:AN32").[/COLOR][COLOR=#333333]Calculate[/COLOR]

HTH

thanks,

Just tried it, it doesn't calculate the range, I think it may need to select it before it calculates it

 

[James006]

Hi,

When it comes o Excel calculation secrets ... THE man is Charles Williams ... !!!

http://www.decisionmodels.com/calcsecretsh.htm


Hope this will help