reset vba vs. macro

[Eddie Wildon]

on one of my sheets I have values returned from a series of formulas. Can someone give me some direction on how to tell a button I added in to clear all the values from those results?

I tried doing this via record macro with no success. I dont want to lose my formulas (they're linked to several other pages), just the values. The cell range affected is b3 to h26 if this helps.

I know this is elementary but so am I....

 

[Richie(UK)]

Hi Eddie,

OK, you want to clear the result of the formula but not delete the formula itself, right?

Seems to me that the only way to do this is to clear the values in the cells that are used by the formulas. (Or, possibly, do delete the formulas themselves but have a macro that reinserts the formulas when you wish).

What is your objective (ie. why do you want to clear the values)?

 

[Eddie Wildon]

my end objective is to clear out my sheet so that the next request will re-populate with new information.