Macro for deleting cell value in excel
Solved/Closed
Mouni369
Masbrow - Feb 11, 2016 at 10:58 PM
- Posts
- 4
- Registration date
- Monday March 12, 2012
- Status
- Member
- Last seen
- July 20, 2012
Masbrow - Feb 11, 2016 at 10:58 PM
Related:
- Delete rows based on a cell value in excel
- Excel - A macro to delete a particular cell value - How-To - Hardware
- Excel Macro for deleting rows IF cells not... ✓ - Forum - Excel
- Excel macro to delete columns based on header ✓ - Forum - Excel
- Excel macro to merge cells based on condition ✓ - Forum - Excel
- Excel - A macro to delete alternate rows - How-To - Office Software
3 replies
rizvisa1
Mar 25, 2012 at 07:51 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Mar 25, 2012 at 07:51 AM
Create a common routine and call that routine
'rowToClearStarting : first row in the range that needs to be cleared 'rowToClearEnding : last row in the range that needs to be cleared 'Sample Call : clearContents(4,6) Public Sub clearContents(rowToClearStarting As Long, rowToClearEnding As Long) Sheets("sheet1").Range("d" & rowToClearStarting & ":d" & rowToClearEnding).clearContents Sheets("sheet1").Range("e" & rowToClearStarting & ":e" & rowToClearEnding).clearContents Sheets("sheet1").Range("g" & rowToClearStarting & ":g" & rowToClearEnding).clearContents Sheets("sheet1").Range("h" & rowToClearStarting & ":h" & rowToClearEnding).clearContents End Sub
Hi Rizvisa1,
Thanks for the reply.
Even this seems to be redundant... can't we specify the entire cells range and clear everything with single clearContents?
Just like range function which selects only one particular cell range, dont we have any other function.
Eg: A1:A5,B2:b8 both the ranges should be given in one particular function and we should be able to delete it .
Eg : sheets("sheet1").<function>("A1:A5","B2:B8").clearContents
Thanks,
Mouni873
Thanks for the reply.
Even this seems to be redundant... can't we specify the entire cells range and clear everything with single clearContents?
Just like range function which selects only one particular cell range, dont we have any other function.
Eg: A1:A5,B2:b8 both the ranges should be given in one particular function and we should be able to delete it .
Eg : sheets("sheet1").<function>("A1:A5","B2:B8").clearContents
Thanks,
Mouni873
rizvisa1
Mar 25, 2012 at 10:21 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Mar 25, 2012 at 10:21 PM
Depends on what you want to do
One way would be
union(range("a1:c4"),range("b4:b6"),range("h4:h5")).clearcontents
One way would be
union(range("a1:c4"),range("b4:b6"),range("h4:h5")).clearcontents