A few words of thanks would be greatly appreciated.

Excel - Delete certain cells of active row

Latest update on March 6, 2010 at 05:18 AM by aakai1056 .

Issue
Solution
Note

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.

Excel - Delete certain cells of active row
Delete certain cells of active row ✓ - Forum - Excel
Excel vba move active cell down one row - Forum - Office Software
Excel highlight active row - How-To - Excel
Excel if a cell contains a word then copy row to another sheet ✓ - Forum - Excel
Duplicate rows in excel based on cell value ✓ - 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).

Automation of running excel macros

Excel - Copy and paste values from specific columns