Consulting

Results 1 to 2 of 2

Thread: Application.Run?

  1. #1
    VBAX Regular
    Joined
    Jul 2017
    Posts
    13
    Location

    Application.Run?

    Hello,

    I have a workbook with the following macro example:

    sub this_macro()
    
    sheet1.select
    range(A1:A20).select
    Application.Run macro:="Some_Name"
    
    end sub

    I have no clue where the Some_Name macro being called by the Application.Run line is. It;s not visible in the VB Editor and I can't find anything with that name anywhere in the workbook. Any thoughts as to where it might be hiding? I think maybe its an XLL but I don't know how to check.

    Appreciate any help, thanks.

  2. #2
    VBAX Expert Leith Ross's Avatar
    Joined
    Oct 2012
    Location
    San Francisco, California
    Posts
    552
    Location
    Hello Bacchus,

    My guess is you have to replace "Some_Name" with the name of macro you want to run.
    Sincerely,
    Leith Ross

    "1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •