reset button to reset selected cells

[AnthonyMinnaar]

Hi,

I was wondering if it's is there's a way to reset a cell, that's been selected by cursor with use of a button.

What I tried using was this: Range ("A1"). Value = ""
but that requires a single button for every single cell that needs to be reset, which goes upto 200 different cells.

Anthony.

 

[Legacy 456155]

If I'm understanding you, use Selection.

If TypeOf Selection Is Range Then Selection.Value = ""

or

If TypeName(Selection) = "Range" Then Selection.Value = ""

See this page for more info.

 

[AnthonyMinnaar]

If I'm understanding you, use Selection.

If TypeOf Selection Is Range Then Selection.Value = ""

or

If TypeName(Selection) = "Range" Then Selection.Value = ""

See this page for more info.

Exactly what I was looking for! Works like a charm, thank you very much!