Excel - Delete certain cells of active row
Issue
I would like a code for the following:
Check which row is active/selected and then delete the data which is in the 5th and 7th column of that row.
I've tried the following:
Sub test() r = ActiveCell.Row Range(r, 5).ClearContents Range(r, 7).ClearContents End Sub
Can someone help me out with this?
Solution
Try:
cells(r,5) and cells(r,7)
Note
Thanks to venka1926 for this tip on the forum.
Related
- Excel - Delete certain cells of active row
- Delete certain cells of active row ✓ - Forum - Excel
- Duplicate rows in excel based on cell value ✓ - Forum - Excel
- Excel VBA to Select Empty Cell in a Row - How-To - Excel
- Macro to insert multiple rows in excel based on cell value - How-To - Excel
- Excel - delete info from a cell found in anot ✓ - Forum - Excel
This document, titled « Excel - Delete certain cells of active row », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).
Subscribe To Our Newsletter!
