LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #19   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default Purging Excel's VM Usage

kittronald explained :
Garry,

The problem ended up being incorrect relative addresses in the
"Fill_Formula" name's Refers to: value.

Since I'm using "=Fill_Formula" with relative addresses, do you still
recommend disabling automatic calculation before setting the Refers to:
value.




- Ronald K.


That's a judgement call YOU have to make based on all what else your
code is doing, and the nature of the formula.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


 
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
purging empty excel files Kayestar Excel Worksheet Functions 1 May 19th 08 03:31 PM
Purging ZIPCODES from a string of cities and zips Bruce Excel Worksheet Functions 7 November 27th 06 10:53 AM
Excel should allow purging since-deleted PivotTable field values. amr Excel Discussion (Misc queries) 1 March 23rd 06 04:33 PM
Add a Excel's references from VB .Net Pablo via OfficeKB.com Excel Programming 0 July 20th 05 05:05 PM
Excel's Dialog Box filo666 Excel Discussion (Misc queries) 3 February 14th 05 11:39 PM


All times are GMT +1. The time now is 04:01 AM.

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

About Us

"It's about Microsoft Excel"