Delete Values from A3, M3 cell when any columns clicked except D & J

**mahmad558** · 06-15-2023, 11:46 AM

I want to delete values from Cell A3 & M3 when clicked on any column except Column "D" & Column "J", below code doesnt do anything except giving error.

r = Range("D")
c = Range("J")
Range("A3,M3").ClearContents

**davesexcel** · 06-15-2023, 11:54 AM

kind of strange, but here is the selection change event for that, any other column but columns D & J will clear the two cells.
Goes in the worksheet module

Please Login or Register  to view this content.

**KOKOSEK** · 06-15-2023, 11:54 AM

You do not show whole code but this part...

Please Login or Register  to view this content.

Delete Values from A3, M3 cell when any columns clicked except D & J

LinkBack

Thread Tools

Rate This Thread

Display

Delete Values from A3, M3 cell when any columns clicked except D & J

Re: Delete Values from A3, M3 cell when any columns clicked except D & J

Re: Delete Values from A3, M3 cell when any columns clicked except D & J

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Use Vlookup as macro on clicked cell and all cell values below that clicked cell

Hide Columns in sheet based on value in double clicked cell

[SOLVED] Load web image when cell holding URL is clicked/double-clicked

[SOLVED] code so that when a cell is clicked, a tick mark goes in the cell that was clicked

Showing data in columns dependent on which cell is clicked

VBA that will delete entire row and shift cells up based on previous columns cell values

Change cell value when right-clicked/double-clicked

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions