Canders_12
asked on
Banish #VALUE! in one fowl swoop
Hello to you all,
I have numbers in the range A1 to C3. One or two have the value "#VALUE!" instead of a number. I would like to add a button to the sheet so when they click it all the "#VALUE!" turn into a "0". Please note, this is NOT a formula so I can't simply sneak an ISERROR() into the little fella.
Your help would be greatly appreciated.
Many thanks in adVANCE, Alan.
I have numbers in the range A1 to C3. One or two have the value "#VALUE!" instead of a number. I would like to add a button to the sheet so when they click it all the "#VALUE!" turn into a "0". Please note, this is NOT a formula so I can't simply sneak an ISERROR() into the little fella.
Your help would be greatly appreciated.
Many thanks in adVANCE, Alan.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Many thanks, Alan