Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default recalculation not recalculating some cells containing user functio

I have the following situation:
1) workbook contains User Function macros in some cells.
2) #VALUE appears in some of the cells
3) if i select the cell and use "F2" to edit then the value is correctly
calculated
4) pressing "F9" will not cause the cells to recalculate nor will
5) running a macro containing the following
Application.CalculateFullRebuild
what must i do to force the cells to recalculate without having to
physically perform
#3 above on each cell.

thanks,

--
jwm
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default recalculation not recalculating some cells containing user functio

application.volatile

at the start of the UDF will make the function volatile and will cause it to
recalc with every calculation. The good new is it will racalc. The bad new is
that it will always recalc which has smoe overhead....
--
HTH...

Jim Thomlinson


"velvetlady" wrote:

I have the following situation:
1) workbook contains User Function macros in some cells.
2) #VALUE appears in some of the cells
3) if i select the cell and use "F2" to edit then the value is correctly
calculated
4) pressing "F9" will not cause the cells to recalculate nor will
5) running a macro containing the following
Application.CalculateFullRebuild
what must i do to force the cells to recalculate without having to
physically perform
#3 above on each cell.

thanks,

--
jwm

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default recalculation not recalculating some cells containing user functio

Make sure you pass all the ranges that your UDF uses to the function.

For more, er, better responses, you should post your code.

velvetlady wrote:

I have the following situation:
1) workbook contains User Function macros in some cells.
2) #VALUE appears in some of the cells
3) if i select the cell and use "F2" to edit then the value is correctly
calculated
4) pressing "F9" will not cause the cells to recalculate nor will
5) running a macro containing the following
Application.CalculateFullRebuild
what must i do to force the cells to recalculate without having to
physically perform
#3 above on each cell.

thanks,

--
jwm


--

Dave Peterson
Reply
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
Hiding rows with cells locked using format protection lock functio John G.[_2_] Excel Discussion (Misc queries) 3 May 7th 08 12:14 AM
weird recalculation of user defined function timspier Excel Worksheet Functions 3 May 14th 06 05:39 AM
Recursive Functio help BigBobbo Excel Worksheet Functions 1 May 10th 06 07:23 PM
Using and IF functio between 2 worksheets. Mike Excel Worksheet Functions 4 January 8th 06 08:34 PM
Today or Now functio Patrick Foley Excel Discussion (Misc queries) 3 March 31st 05 02:35 AM


All times are GMT +1. The time now is 01:28 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"