Results 1 to 2 of 2
  1. #1
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664

    Macro button fails to work

    In the zipped file attached to this post is a file


    testbook.xlxm.

    I have a button in the spreadsheet area that when I click on it supposed to delete rows 9 to 11.

    It does not. I believe that the VBA code is correct.

    What is wrong.

    Any help appreciated. Thanks in advance.

    Respectfully,

    Lou Reed
    Attached Files Attached Files

  2. #2
    Micron is offline Very Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,369
    You could simplify things for everyone by posting code when it's such a minor procedure instead of us having to download, store a file, unzip it, then open it, then navigate to your 3 lines of code.
    Try Range("A1:A4").Delete
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Macro fails on closing form
    By Lou_Reed in forum Access
    Replies: 6
    Last Post: 07-17-2017, 01:35 PM
  2. Making a button with a macro work
    By clrockwell15 in forum Macros
    Replies: 3
    Last Post: 06-23-2017, 12:51 PM
  3. Macro doesn't work 100%
    By ITVader in forum Macros
    Replies: 28
    Last Post: 11-17-2016, 08:51 AM
  4. Command Button to Run Macro, can't find macro
    By Ace2014 in forum Modules
    Replies: 22
    Last Post: 06-11-2014, 11:42 AM
  5. Replies: 0
    Last Post: 01-12-2011, 12:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums