Error 1004: Calculate Method of Range Class Failed
I have a very short and simple macro, whose purpose is to calculate the
selected range (thereby avoiding the time it takes to calc the entire sheet). Sub Recalc_Range() Selection.Calculate End Sub I was running Excel 97, and it worked fine. Now that I have updated to Excel XP, I get the following error message: "Calculate Method of Range Class Failed" I am stumped. I've tried a variety of things, like setting a range variable equal to the current selection, then running the calculate function on that range. Same error message. I have also read that you may get this error message if the Range has no data. My range has data, so that is not it. Any help is greatly appreciated. Dan |
Error 1004: Calculate Method of Range Class Failed
Hi Dan,
Does this help? http://support.microsoft.com/default...b;en-us;292476 -- Regards, Jake Marx www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Dan Winterton wrote: I have a very short and simple macro, whose purpose is to calculate the selected range (thereby avoiding the time it takes to calc the entire sheet). Sub Recalc_Range() Selection.Calculate End Sub I was running Excel 97, and it worked fine. Now that I have updated to Excel XP, I get the following error message: "Calculate Method of Range Class Failed" I am stumped. I've tried a variety of things, like setting a range variable equal to the current selection, then running the calculate function on that range. Same error message. I have also read that you may get this error message if the Range has no data. My range has data, so that is not it. Any help is greatly appreciated. Dan |
Error 1004: Calculate Method of Range Class Failed
I meant does that fit your situation rather than error.
this provides a little more background: http://support.microsoft.com/default...b;en-us;827990 Circular reference does not calculate during Range.Calculate execution in Excel 2002 here is a less likely cause: http://support.microsoft.com/default...b;en-us;825011 XL2002: You Receive an Error Message When You Use the Range.Calculate Method to Calculate Formulas just a general reference: http://support.microsoft.com/default...b;en-us;825012 How formula calculations are performed in Excel 2002 or Excel 2003 -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... http://support.microsoft.com/default...b;en-us;292476 Does that fit your situation? -- Regards, Tom Ogilvy "Dan Winterton" <Dan wrote in message ... I have a very short and simple macro, whose purpose is to calculate the selected range (thereby avoiding the time it takes to calc the entire sheet). Sub Recalc_Range() Selection.Calculate End Sub I was running Excel 97, and it worked fine. Now that I have updated to Excel XP, I get the following error message: "Calculate Method of Range Class Failed" I am stumped. I've tried a variety of things, like setting a range variable equal to the current selection, then running the calculate function on that range. Same error message. I have also read that you may get this error message if the Range has no data. My range has data, so that is not it. Any help is greatly appreciated. Dan |
Error 1004: Calculate Method of Range Class Failed
Perfect. Thanks.
"Tom Ogilvy" wrote: http://support.microsoft.com/default...b;en-us;292476 Does that fit your situation? -- Regards, Tom Ogilvy "Dan Winterton" <Dan wrote in message ... I have a very short and simple macro, whose purpose is to calculate the selected range (thereby avoiding the time it takes to calc the entire sheet). Sub Recalc_Range() Selection.Calculate End Sub I was running Excel 97, and it worked fine. Now that I have updated to Excel XP, I get the following error message: "Calculate Method of Range Class Failed" I am stumped. I've tried a variety of things, like setting a range variable equal to the current selection, then running the calculate function on that range. Same error message. I have also read that you may get this error message if the Range has no data. My range has data, so that is not it. Any help is greatly appreciated. Dan |
Error 1004: Calculate Method of Range Class Failed
Perfect. Thanks.
"Jake Marx" wrote: Hi Dan, Does this help? http://support.microsoft.com/default...b;en-us;292476 -- Regards, Jake Marx www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Dan Winterton wrote: I have a very short and simple macro, whose purpose is to calculate the selected range (thereby avoiding the time it takes to calc the entire sheet). Sub Recalc_Range() Selection.Calculate End Sub I was running Excel 97, and it worked fine. Now that I have updated to Excel XP, I get the following error message: "Calculate Method of Range Class Failed" I am stumped. I've tried a variety of things, like setting a range variable equal to the current selection, then running the calculate function on that range. Same error message. I have also read that you may get this error message if the Range has no data. My range has data, so that is not it. Any help is greatly appreciated. Dan |
Error 1004: Calculate Method of Range Class Failed
Does anyone know of a workaround other than turning off the Iterations
count? Having Iterations and Manual Calc mode ON is a very useful combo in many cases. thanks Dan Winterton wrote: Perfect. Thanks. "Tom Ogilvy" wrote: http://support.microsoft.com/default...b;en-us;292476 Does that fit your situation? -- Regards, Tom Ogilvy "Dan Winterton" <Dan wrote in message ... I have a very short and simple macro, whose purpose is to calculate the selected range (thereby avoiding the time it takes to calc the entire sheet). Sub Recalc_Range() Selection.Calculate End Sub I was running Excel 97, and it worked fine. Now that I have updated to Excel XP, I get the following error message: "Calculate Method of Range Class Failed" I am stumped. I've tried a variety of things, like setting a range variable equal to the current selection, then running the calculate function on that range. Same error message. I have also read that you may get this error message if the Range has no data. My range has data, so that is not it. Any help is greatly appreciated. Dan |
All times are GMT +1. The time now is 03:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com