Results 1 to 8 of 8

Debug this?

Threaded View

  1. #1
    Registered User
    Join Date
    10-14-2003
    Posts
    7

    Debug this?

    This line:

    Set wksA = gwbB.Names("aName").RefersToRange.Parent

    produces the 1004 Application or object defined error in my program, and I can`t figure out why. The statement resides in an addin and tries to set a reference to a sheet (in another project) with a range referred to by the name aName.

    wksA is local to the sub in which the error occurs. wksA is declared as

    Dim wksA as Worksheet

    Debug.print gwkbB.Name shows me the name of the project is correct and the project certainly has the name aName in it and it refers to a range ok.

    Could it be that one needs to set a reference to some special object library to do this?

    Any help is much appreciated.
    Last edited by hke; 05-11-2005 at 09:04 AM. Reason: Added more info

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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