macro to Clear items after - in cell D37 on certain sheets

**Howardc1001** · 06-27-2022, 04:36 AM

I have code to clear data in Cell D37 on sheets BR1 BTY to BR5 BTY

I would like this amended to only clear the data after the dash in cell D37

your assistance is most appreciated

Please Login or Register  to view this content.

**bebo021999** · 06-27-2022, 04:54 AM

Your actual tab's name do not have "Cheque advice ..." before then code do not work.
Altenative:

HTML Code:

**Howardc1001** · 06-27-2022, 05:20 AM

sorry , I changed cheque advise to Payment Advise

Thanks for the code. I made once small change as -needed to ve retain. Only need to clear data after the dash

Changed

Please Login or Register  to view this content.

macro to Clear items after - in cell D37 on certain sheets

LinkBack

Thread Tools

Rate This Thread

Display

macro to Clear items after - in cell D37 on certain sheets

Re: macro to Clear items after - in cell D37 on certain sheets

Re: macro to Clear items after - in cell D37 on certain sheets

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to clear #Value Items in Col B

[SOLVED] macro to find and clear unwanted Items

[SOLVED] Macro to clear CF in Col B and copy non CF items

[SOLVED] Macro to clear Fill Coloured items only from row 9 in Col E

[SOLVED] Macro to clear specific Items

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

Need to clear sheets everytime MAcro is run

Bookmarks

Bookmarks

Posting Permissions