Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am having a major problem with these two lines of code in my otherwise
great reporting tool: Worksheets("Goals Tracker").Select Worksheets("Goals Tracker").Range("G3:GA712").Calculate These 2 lines freezes up my computer to the point that I can't use any other application on my computer. It takes forever (over an hour, the last time I let it run complete) to calculate one sheet in the workbook. I need to find out if there is another way to get this done faster. Any help will be appreaciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
problem building Function with worksheet name and range | Excel Programming | |||
Sort Worksheet Range from another worksheet range, Excel 2000 & 2003 | Excel Programming | |||
Can I calculate just one worksheet in a multi-worksheet workbook? | Excel Discussion (Misc queries) | |||
Formula to retrieve range of dates from a worksheet to calculate d | Excel Worksheet Functions | |||
Findjjing the range that triggered worksheet calculate | Excel Programming |