Results 1 to 28 of 28

Delete all

Threaded View

  1. #8
    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.

    My head is spinning a bit after this so I hope this version has you sorted!

    I added a code which allows you to show or hide the Add formulas to sheets button- to show the button, type "show" in cell C1 of the FRONT sheet (no inverted commas, case sensitive). To hide it, type "hide" (same rules).

    The 'Delete all button is generally visible at the extreme right of the FRONT worksheet, occasionally a little cut off but I ended up not grasping the nature of how it has to be positioned.
    Clicking it deletes any free text from the relevant sheet as well as the specified content on the FRONT sheet.
    Attached Files Attached Files

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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1