+ Reply to Thread
Results 1 to 3 of 3

Sorting a table with a macro - code not working

  1. #1
    Registered User
    Join Date
    07-22-2014
    Location
    London
    MS-Off Ver
    2010
    Posts
    30

    Sorting a table with a macro - code not working

    Hi guys,

    I have trying to use Dave Peterson's hidden rectangle VBA on my table, however, VBA editor saying it is unable to run due to the highlighted red line in the code below. I have a worksheet macro in the workbook I am trying to incorporate it, is this likely to be the issue? (I have no experience with macro/VBA) The code works fine in a workbook on it's own. Could any suggest a fix? Thanks!

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,173

    Re: Sorting a table with a macro - code not working

    Did you see what the value of : Application.Caller is?
    It may not be what you think.

  3. #3
    Registered User
    Join Date
    07-22-2014
    Location
    London
    MS-Off Ver
    2010
    Posts
    30

    Re: Sorting a table with a macro - code not working

    Hi Ranman256,

    Thanks for your reply. In truth, I am not sure I understand the question (my VBA knowledge is next to nothing really)?

    I also meant to add that the Error Code be raised by the VBA editor is Error 2023.

    Let me know if there is anything I can do to help or if any more info is required!

+ 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] add sorting formula on working code of macros
    By greatairi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-24-2013, 11:29 AM
  2. Replies: 1
    Last Post: 10-04-2013, 05:54 PM
  3. Help! Macro for Table Sorting
    By jsuarez199 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-21-2013, 03:09 AM
  4. [SOLVED] Sorting on textbox input - Problems when inserting a new row (macro stops working)
    By adrianrff in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2013, 05:03 PM
  5. Sorting Dates in a Pivot Table is not working
    By Excel_vba in forum Excel General
    Replies: 1
    Last Post: 10-09-2012, 02:31 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