+ Reply to Thread
Results 1 to 28 of 28

Delete all

Hybrid View

  1. 11-30-2023, 06:55 PM #1
    deadlyduck
    deadlyduck is offline
    Valued Forum Contributor
    Join Date
    08-31-2007
    Location
    SW Ireland
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2311 Build 16.0.17029.20068) 32-bit
    Posts
    540

    Re: Delete all

    OK- here's hoping!

    Does the attached work for you?
    Attached Files Attached Files
    Last edited by deadlyduck; 12-01-2023 at 11:04 AM.
    Excel 365 user. To unblock a downloaded macro-enabled workbook, go to your "Downloads" folder > right click on the workbook name > click 'Properties' > check the 'Unblock' checkbox. You can now open the workbook.
    Reply With QuoteRegister To Reply
  2. 12-01-2023, 06:21 PM #2
    stevejd 58
    stevejd 58 is offline
    Registered User
    Join Date
    08-20-2019
    Location
    UK
    MS-Off Ver
    2019
    Posts
    17

    Re: Delete all

    I think we've cracked it
    now to fully test it
    thank you very much for your hard work
    Reply With QuoteRegister To Reply
  3. 12-01-2023, 06:45 PM #3
    deadlyduck
    deadlyduck is offline
    Valued Forum Contributor
    Join Date
    08-31-2007
    Location
    SW Ireland
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2311 Build 16.0.17029.20068) 32-bit
    Posts
    540

    Re: Delete all

    Good stuff.

    Leave a comment here if you find something that needs sorting.

    Have fun with the use of the workbook!
    Reply With QuoteRegister To Reply
  4. 12-20-2023, 06:07 PM #4
    stevejd 58
    stevejd 58 is offline
    Registered User
    Join Date
    08-20-2019
    Location
    UK
    MS-Off Ver
    2019
    Posts
    17

    Re: Delete all

    Hi Deadly Duck
    Finally got time to sit and test this, all looking good apart from 3 cells in sheets 1 to 18.
    Cells E6, G6 & C26 don't clear when "Delete all" is clicked on the front page.
    The data on the test sheet is just some random rubbish for testing purposes.
    Merry Christmas
    Stevejd 58

    Langworth PSAG 2023 ver 3c test sheet .xlsm
    Last edited by stevejd 58; 12-27-2023 at 06:11 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Delete Method of Range Class Failed on SpecialCells(xlCellTypeBlanks).EntireRow.Delete
    By BFid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-06-2021, 11:27 AM
  2. [SOLVED] Adding delete code on userform to delete a row on sheet by selecting item on a listbox
    By darbar76528 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-07-2020, 12:50 PM
  3. VBA code to delete the FILTERED range and moving the cell up (dont Delete entire row)
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-14-2015, 07:48 AM
  4. cannot delete worksheets. The excel file not shared. The delete option is grayed.
    By JOMOLA in forum Excel General
    Replies: 1
    Last Post: 11-30-2013, 06:37 AM
  5. [SOLVED] Macro to delete sheets and saves remaining file does not properly delete module
    By pherrero in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-21-2005, 08:12 PM
  6. [SOLVED] Re: Macro to delete sheets and saves remaining file does not properly delete module
    By bhawane in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-21-2005, 01:05 PM
  7. [SOLVED] Re: Macro to delete sheets and saves remaining file does not properly delete module
    By pherrero in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-21-2005, 01:05 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1