Excel - Delete certain cells of active row
Ask a question
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 (Solved) » Forum - Excel
- Macro to copy a certain cell onto another row (Solved) » Forum - Excel
- Excel - A macro to delete rows with specific values » How-To - Excel
- Auto insert 'x' rows depending on value 'y' » Forum - Excel
- Excel VBA - Selecting the next empty cell in a row » How-To - Excel