ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   functions run 2 times. (https://www.excelbanter.com/excel-programming/294433-functions-run-2-times.html)

y

functions run 2 times.
 
It seems to me the function I'm debugging runs two times.

I called it only one time in my workbook.

I set up a break line and when I arrive at the end of the function VBA moves to the break line again
ready to continue. Then I go on and finally at the end of the function the code stop to run.

Does anybody know why?

Thanks alex.


Frank Kabel

functions run 2 times.
 
Hi Alex
could you post your code?

--
Regards
Frank Kabel
Frankfurt, Germany


y wrote:
It seems to me the function I'm debugging runs two times.

I called it only one time in my workbook.

I set up a break line and when I arrive at the end of the function
VBA moves to the break line again ready to continue. Then I go on and
finally at the end of the function the code stop to run.

Does anybody know why?

Thanks alex.



y

functions run 2 times.
 
Now it seems to run fine and only one time.

At this time I'm not able to reproduce the behavior I described.
If it so in the future I'll post it to the NG.

Thanks for your interest, Alex.


Charles Williams

functions run 2 times.
 
This is quite common,

see http://www.decisionmodels.com/calcsecretsj.htm

regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

"y" wrote in message ...
It seems to me the function I'm debugging runs two times.

I called it only one time in my workbook.

I set up a break line and when I arrive at the end of the function VBA

moves to the break line again
ready to continue. Then I go on and finally at the end of the function the

code stop to run.

Does anybody know why?

Thanks alex.





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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com