+ Reply to Thread
Results 1 to 2 of 2

Thread: Storing and using objects in variables.

  1. #1
    Registered User
    Join Date
    11-16-2008
    Location
    MN
    Posts
    1

    Storing and using objects in variables.

    I have multiple windows open on one file. I want to store the active window in a variable and then be able to call it later, and i can't figure out how to do it. Here's what i tried.

    Dim iVar1 as Object
       Set iVar1 = ActiveWindow
    Windows (iVar1).Activate
    Do you understand my question? Is there a way to make it work?
    Last edited by VBA Noob; 11-16-2008 at 04:58 PM. Reason: Added code tags as per forum ruls

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    MS Excel 2010
    Posts
    2,247
    Almost there

    Dim iVar1 As Object
        Set ivar1 = ActiveWindow
        iVar1.Activate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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.2.0