Clear cell function

[Brent Fanguy]

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

Is there such a function?

TIA

Brent Fanguy

 

[Harlan Grove]

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

Is there such a function?

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

Range("A720000").Clear

or

Range("A720000").ClearContents

 

[Guest]

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("A720000").Clear

or

Range("A720000").ClearContents

 

[Gord Dibben]

Brent

Range("A72000").Clear

Alternate..........

Tools>Macro>Record New Macro.

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

Gord Dibben Excel MVP