I have a macro that detects duplicates and deletes the entire row. My question is, is there a way to only delete certain columns in that row?
Please Login or Register to view this content.
I have a macro that detects duplicates and deletes the entire row. My question is, is there a way to only delete certain columns in that row?
Please Login or Register to view this content.
This clears cells C and D in the row.
Rows(x).Range("C1:D1").ClearContents
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi,
Do you really mean delete certain cells in that row since the concept of deleting certain columns in a row without also deleting those same columns in other rows is new to me?
Perhaps you mean delete the value in a certain cell by shuffling all the other cells on that row across by one?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Do you mean Columns or cells in that row. This will delete Columns on each occurance of greater than 1?
Not sure this is what you want though.Please Login or Register to view this content.
Sorry for the confusion, yes I mean deleting only certain cells in that row. Cells A,B,C,D
AlphaFrog
That worked well thank you all for the speedy response I will mark this thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks