Delete Cell Value but keep the cell formula through VBA and Manually
Hello,
I have created a excel workbook, it has formulas in the cell.
I want to allow to user to delete values of the cell which was calculated by the formula but keep the formula in-tact.
I want to create a Reset button through which I will remove all the values of the cell and keep the formula in the cell.
Please let me know if I am not clear.
Thanks for any help you will provide.
Regards,
Amit
You either delete the formula or don't.
What are you trying to do?
A formula is dependent on other cells, usually. If you want to clear the value but retain the formula, you will have to clear the content of the other cells.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi,
I have tried creating an example for you. Please check the attachment. I am beginner VBA programmer. See, this is what you want?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks