Change Macro to stop deleting cells in 2 columns

**CHRISTINEKENDALL93** · 11-20-2018, 04:22 PM

I have been using a macro for awhile and it works except I‘m need help a small change to what cells get deleted in only one specific column. If someone could kindly assist.
Using the sample Excel sheet image I uploaded, my macro currently deletes cells in the following columns B,C and D. For only the cell range A20:A34 I would like the macro to only delete cells in the B column. The rest of the marco is perfect as it is.
That’s it. hanks in advance for your help.

Please Login or Register  to view this content.

NEW EXCEL SHEET.JPEG

**Bernie Deitrick** · 11-20-2018, 05:04 PM

Try replacing

Please Login or Register  to view this content.

with

'---- This clears the B/EFG/IJK columns after using the value ----

Please Login or Register  to view this content.

**CHRISTINEKENDALL93** · 11-21-2018, 03:53 PM

Hii Bernie

Just tried the change and columns EFG and IJK get deleted correctly but not the B column. It deletes B/C/D. I only need the B deleted. I tried and tried it's driving me crazy, not sure what's wrong?

Thanks so much for your help.

**Bernie Deitrick** · 11-21-2018, 04:31 PM

The code that I posted will not clear columns BCD. Here is that some code, basically, to be run on a new blank worksheet. DO NOT run it on your current workbook.

I have included code to populate the sheet in a way that only cells in row 22 will be cleared. Afer you run the code, you can see that column B is cleared but not C or D.

If you remove the 7 lines of code from the section under 'code to fill then the code will work on your existing sheet.

Please Login or Register  to view this content.

**CHRISTINEKENDALL93** · 11-26-2018, 04:42 PM

Hi Bernie

Sorry for the delay in getting back to you but that did the trick.

Thanks so much for your help.

Change Macro to stop deleting cells in 2 columns

LinkBack

Thread Tools

Rate This Thread

Display

Change Macro to stop deleting cells in 2 columns

Re: Change Macro to stop deleting cells in 2 columns

Re: Change Macro to stop deleting cells in 2 columns

Re: Change Macro to stop deleting cells in 2 columns

Re: Change Macro to stop deleting cells in 2 columns

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Stop Worksheet change event from interfering with macro code

Macro to change cells reference addres (+35 in rows, +2 in columns)

Macro to stop deleting data when a certain row is reached

Macro Adjustment Needed To Stop Deleting Row When Cancelled

Stop Macro if blank cells are within certain columns

How to stop file open macro prompt after deleting all macros?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions