make worksheet active

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: make worksheet active

  1. #1
    Board Regular
    Join Date
    Oct 2004
    Location
    Atlanta, GA
    Posts
    240
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default make worksheet active

     
    I recorded a macro in Excel that I am calling from Access. However, the Macro is not working on the required worksheet.

    I need to make 'qryTransfer1' the active worksheet before the range I have is selected.

    I tried

    Code:
    qryTransfer1.Activate
    But I need to add something to the procedure.

    Can anyone help?

    Thanks in advance

  2. #2
    New Member
    Join Date
    Jul 2005
    Location
    Newcastle Upon Tyne
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: make worksheet active

    Hello,

    try

    Sheets("qryTransfer1").Activate

    or am I being a bit simplistic?

  3. #3
    Board Regular
    Join Date
    Oct 2004
    Location
    Atlanta, GA
    Posts
    240
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: make worksheet active

      
    I was looking at other samples on here and saw how they were putting

    Code:
    sheets(1).Activate
    I guess I was looking at that as 'Sheet1'


    Thanks for the help

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com