1
1vagrowr
Is there a way to make a "reset" button to clear only select cells?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave
Hi 1vagrowr
Assuming you are selecting cells manually, why don't you just use the delete
button?
Dave.
Assuming you are selecting cells manually, why don't you just use the delete
button?
Dave.
M
Max
There were 2 responses (from me and Bob Phillips) to your earlier 2
identical questions in this newsgroup some 3 days ago, which have not
received any feedback from you in the threads.:
a, http://tinyurl.com/bmrs5
(Bob Phillips)
b. http://tinyurl.com/bqg7y
(Max)
identical questions in this newsgroup some 3 days ago, which have not
received any feedback from you in the threads.:
a, http://tinyurl.com/bmrs5
(Bob Phillips)
b. http://tinyurl.com/bqg7y
(Max)
N
Norman Jones
Hi Ivagrwr,
In addition to the responses indicated by Max, if the cells to be cleared
are constant, try assigning the following macro to your button:
'=============>>
Sub ClearCells()
Dim Rng As Range
Set Rng = Range("A1:A20") '<<==== CHANGE
Rng.Clear
End Sub
'<<=============
If your intention is to delete the contents but retain formats, change:
Rng.Clear
to:
Rng.ClearContents
If you are not familiar with macros, you may wish to visit David McRitchie's
'Getting Started With Macros And User Defined Functions' at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
In addition to the responses indicated by Max, if the cells to be cleared
are constant, try assigning the following macro to your button:
'=============>>
Sub ClearCells()
Dim Rng As Range
Set Rng = Range("A1:A20") '<<==== CHANGE
Rng.Clear
End Sub
'<<=============
If your intention is to delete the contents but retain formats, change:
Rng.Clear
to:
Rng.ClearContents
If you are not familiar with macros, you may wish to visit David McRitchie's
'Getting Started With Macros And User Defined Functions' at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
D
David
Norman Jones wrote
Jumping in late here so don't know the OP's intent, but it seems fair to
point out that .Clear as opposed to .ClearContents clears everything,
including borders, Conditional Formatting, etc.
Sub ClearCells()
Dim Rng As Range
Set Rng = Range("A1:A20") '<<==== CHANGE
Rng.Clear
End Sub
Jumping in late here so don't know the OP's intent, but it seems fair to
point out that .Clear as opposed to .ClearContents clears everything,
including borders, Conditional Formatting, etc.
N
Norman Jones
Hi David,
Hence my comment to the OP:
It is certainly fair to comment, but it is undoubtedly misleading to excise
the section of my response most directly pertinent to your comment.
Jumping in late here so don't know the OP's intent, but it seems fair to
point out that .Clear as opposed to .ClearContents clears everything,
including borders, Conditional Formatting, etc.
Hence my comment to the OP:
It is certainly fair to comment, but it is undoubtedly misleading to excise
the section of my response most directly pertinent to your comment.
D
David
Norman Jones wrote
Apologies. Totally missed that section. It was 5:00am and my eyes weren't
working yet.
It is certainly fair to comment, but it is undoubtedly misleading to
excise the section of my response most directly pertinent to your
comment.
Apologies. Totally missed that section. It was 5:00am and my eyes weren't
working yet.
1
1vagrowr
Sorry, guys. The post wasn't displaying where I posted it (Excel general
?s). I happened across it just now when I displayed all threads.
?s). I happened across it just now when I displayed all threads.
M
Max
Don't know what happened, but trust that you've got what you wanted since,
from the many responses provided ..
from the many responses provided ..