Clear cell function

  • Thread starter Thread starter Brent Fanguy
  • Start date Start date
B

Brent Fanguy

I want to create a command button that when pressed will
clear a predefined cell range.
Example: Clear(A7:D20000)

Is there such a function?

TIA

Brent Fanguy
 
I want to create a command button that when pressed will
clear a predefined cell range.
Example: Clear(A7:D20000)

Is there such a function?
Click to expand...

Function? No. Your button would need to call a macro that would run a statement
like

Range("A7:D20000").Clear

or

Range("A7:D20000").ClearContents
 
works like a charm.

thank you very much.

-----Original Message-----
...

Function? No. Your button would need to call a macro that would run a statement
like

Range("A7:D20000").Clear

or

Range("A7:D20000").ClearContents
Click to expand...
 
Brent

Range("A7:D2000").Clear

Alternate..........

Tools>Macro>Record New Macro.

When recording is complete, assign the macro to a button.

Gord Dibben Excel MVP
 
Back
Top