LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Problem with .Calculate

Hello,

Both these pieces of code work in Excel 97 and 2000, but not in 2003

Range("C1:D9").Calculate

Worksheets("Sheet1").UsedRange.Columns("A:C").Calc ulate

I get error 1004, "Calculate method of range class failed"

Any ideas why?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
problem with a function to calculate weighted test score Drew P. Excel Worksheet Functions 2 September 17th 09 12:55 PM
UDF To Calculate Work hours between two dates Problem with code jlclyde Excel Discussion (Misc queries) 4 August 13th 07 06:47 PM
calculate problem in excel Ohmega Excel Worksheet Functions 5 July 8th 05 12:06 AM
Excel VBA Calculate Problem DeepThought Excel Programming 2 January 7th 04 08:42 PM
Problem to calculate cells Ben.c Excel Programming 2 December 29th 03 10:16 AM


All times are GMT +1. The time now is 07:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"