Macro Clear Button

G

GregoryT

New Member
Joined
Oct 30, 2019
Messages
10
I have created a clear button on my sheet to reset certain cells to 0 etc.

However in some of the cells formulas are also being deleted. Can someone tell me how to correct this problem, leave the formulas intact.

Thanks all
GT
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Fluff

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,821
Office Version
365
Platform
Windows
Something along the lines of
Code: 
Range("A1:Z100").SpecialCells(xlConstants).Value = 0
 
You must log in or register to reply here.

Watch MrExcel Video

Excel Number The Visible Rows - 2328

Forum statistics

Threads
1,095,869
Messages
5,446,980
Members
405,424
Latest member
fidarbearing

Share this page

This Week's Hot Topics

Top