G
Guest
Im using excel 2000, why when I use countif on the toolbar does excel crash?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Can you give an xample?
G
Guest
I type or click =, I then click the countif button or the arrow leading to
the countif and other choices, the error message then comes up that excel had
encountered a problem and needs to close and excel closes not saving any data
entered.
Can you help?
Mo
the countif and other choices, the error message then comes up that excel had
encountered a problem and needs to close and excel closes not saving any data
entered.
Can you help?
Mo
G
Guest
Hi Mo,
It sounds like you are using a generated button, driven by a macro? This
certainly is not a standard Excel option.
What happens if you type in you're formula without clicking this
Countifbutton?
If you click on <Alt><F11>, can you see any code to generate a menu item?
If so, clearly something went wrong in the macro, and you'll have to either
repair, or delete it.
It sounds like you are using a generated button, driven by a macro? This
certainly is not a standard Excel option.
What happens if you type in you're formula without clicking this
Countifbutton?
If you click on <Alt><F11>, can you see any code to generate a menu item?
If so, clearly something went wrong in the macro, and you'll have to either
repair, or delete it.
G
Guest
Thanks a lot got it sorted & working ok now thank you