Macro to clear last item in a Colunmn

**Howardc1001** · 07-24-2019, 06:04 AM

I have the following macro, which I want to clear the clear item in col H as well as 8 columns to the right

When running the macro, it clears my headings as well

Please Login or Register  to view this content.

It would be appreciated if someone could assist me in resolving this

**TMS** · 07-24-2019, 06:22 AM

Maybe, untested:

Please Login or Register  to view this content.

**MrGes** · 07-24-2019, 06:35 AM

Hi,
tray this:

Please Login or Register  to view this content.

**jindon** · 07-24-2019, 06:41 AM

Try

Please Login or Register  to view this content.

**Howardc1001** · 07-24-2019, 09:40 AM

Hi Guys

Thanks for the help

**TMS** · 07-24-2019, 10:21 AM

You're welcome. Thanks for the rep.

Macro to clear last item in a Colunmn

LinkBack

Thread Tools

Rate This Thread

Display

Macro to clear last item in a Colunmn

Re: Macro to clear last item in a Colunmn

Re: Macro to clear last item in a Colunmn

Re: Macro to clear last item in a Colunmn

Re: Macro to clear last item in a Colunmn

Re: Macro to clear last item in a Colunmn

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro VBA to Copy & Paste Cell Item to another Cell Item

[SOLVED] Macro VBA to Copy & Paste Cell Item to another Cell Item

[SOLVED] Macro in excel for converting forecast Child Item (BoM) to Parent Item (SKU)

a macro to clear a range of data based on cell result - i.e. if A1 = A2, clear C1: C10

Clear/Hide/Add Item to a combo box from VBA code

Clear formfileds macro is blocking other macro to work in Word 2003Hi, I am not a VB

macro to create a new tool bar, add a custom menu item, name property & assign macro

Bookmarks

Bookmarks

Posting Permissions