worksheet selection change
I have a subroutine that I would like to run when any cell on a
worksheet changes. I can run the subroutine without a problem by adding a button to the worksheet and pointing it to that particular macro. but when I try to add the worksheet change event I am getting errors. It seems to be a problem with an addin that solved cubic equations. whenever the sub is called from the worksheet change event, the results are #value which causes an error. I don't understand what the difference is if I run the macro from a button or a change event. any ideas? thanks, Jacob |
All times are GMT +1. The time now is 02:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com