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: 2
Default Forcing Evaluation of Functions

I have created a function in VBA and refer to it in
various places on a worksheet - it produces correct
results when I initially hit enter on the cell. When the
data it uses changes, the cell with the function in it
does not automatically change (like it would with a
formula). If I go to the cell and hit enter in the input
area, it does correctly re-evaluation the function.

Is there a command I can run that will force it to re-
evaluate the function on the whole worksheet (without me
hitting enter on each cell).

Thanks for any suggestions,
Meryl
 
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
Performance Evaluation Free Bird Katie Excel Discussion (Misc queries) 1 June 23rd 09 09:26 PM
Vlookup evaluation Mick[_2_] Excel Worksheet Functions 2 February 25th 08 02:22 PM
Evaluation Sheet perplexed Excel Worksheet Functions 2 March 10th 06 10:51 PM
dealer evaluation AB Excel Worksheet Functions 1 June 15th 05 02:17 PM
Options Evaluation Michael G. Excel Worksheet Functions 0 January 28th 05 05:41 PM


All times are GMT +1. The time now is 06:41 PM.

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"