+ Reply to Thread
Results 1 to 28 of 28

Delete all

Hybrid View

stevejd 58 Delete all 11-24-2023, 04:59 PM
deadlyduck Re: Delete all 11-25-2023, 10:29 AM
stevejd 58 Re: Delete all 11-25-2023, 04:51 PM
deadlyduck Re: Delete all 11-26-2023, 10:00 AM
stevejd 58 Re: Delete all 11-27-2023, 04:18 PM
deadlyduck Re: Delete all 11-28-2023, 04:36 PM
stevejd 58 Re: Delete all 11-28-2023, 05:09 PM
deadlyduck Re: Delete all 11-29-2023, 05:04 PM
stevejd 58 Re: Delete all 11-30-2023, 04:44 PM
deadlyduck Re: Delete all 11-30-2023, 04:55 PM
deadlyduck Re: Delete all 11-30-2023, 05:06 PM
stevejd 58 Re: Delete all 11-30-2023, 05:16 PM
deadlyduck Re: Delete all 11-30-2023, 05:20 PM
stevejd 58 Re: Delete all 11-30-2023, 05:42 PM
deadlyduck Re: Delete all 11-30-2023, 05:50 PM
stevejd 58 Re: Delete all 11-30-2023, 06:24 PM
deadlyduck Re: Delete all 11-30-2023, 06:55 PM
stevejd 58 Re: Delete all 12-01-2023, 06:21 PM
deadlyduck Re: Delete all 01-09-2024, 06:56 AM
stevejd 58 Re: Delete all 01-09-2024, 04:15 PM
deadlyduck Re: Delete all 01-10-2024, 04:23 PM
stevejd 58 Re: Delete all 01-10-2024, 04:51 PM
stevejd 58 Re: Delete all 01-22-2024, 04:15 PM
deadlyduck Re: Delete all 02-05-2024, 06:02 PM
stevejd 58 Re: Delete all 04-02-2024, 04:41 PM
stevejd 58 Re: Delete all 06-05-2024, 05:02 PM
  1. #1
    Registered User
    Join Date
    08-20-2019
    Location
    UK
    MS-Off Ver
    2019
    Posts
    17

    Re: Delete all

    Hi
    The "delete all" buttons need to sit in the corresponding rows of column AE, I tried moving them but the just bounce back to area to the right. For the front page, anything right of the blue won't be visible on the display screen.
    Just tried testing functionality but I'm getting Runtime Error 1004 popups on every page change

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

    I misinterpreted this sentence: "as to the delete all button, I could do with that being visible at the end of each row again with the protective pop up." I understood it to require that the button was visible at the end of the rightmost visible cell. Column AE won't always be visible unless you scroll across. In any case, I've changed the code to have the button automatically stay in column AE.

    What page / what cells are you trying to change that triggers the error? I changed a few random cells on the FRONT sheet and on one of the added sheets- all went OK here.
    Attached Files Attached Files
    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 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] 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. 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. 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