+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,018

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

    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.
    Attached Files Attached Files
    Last edited by Howardc1001; 06-27-2022 at 04:38 AM.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,439

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

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

  3. #3
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,018

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

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to clear #Value Items in Col B
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-29-2021, 07:32 AM
  2. [SOLVED] macro to find and clear unwanted Items
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-20-2021, 08:26 AM
  3. [SOLVED] Macro to clear CF in Col B and copy non CF items
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-20-2021, 08:50 AM
  4. [SOLVED] Macro to clear Fill Coloured items only from row 9 in Col E
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2020, 11:51 PM
  5. [SOLVED] Macro to clear specific Items
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-10-2019, 03:00 AM
  6. Replies: 1
    Last Post: 06-21-2013, 04:05 AM
  7. Need to clear sheets everytime MAcro is run
    By Fferjay in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-02-2011, 12:01 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1