Solved

Trying to select cell "A3" after selecting a sheet

Posted on 2011-03-18
3
294 Views
Last Modified: 2012-05-11
After I have select a sheet based on the value of a cell in the current sheet, I want to select cell "A3" on the new sheet.

My current code is:

        Sheets(Range("AC3").Value).Select
        Range("A3").Select

But this does not change the cell selection for the new sheet.
0
Comment
Question by:jmkbrown
3 Comments
 
LVL 81

Accepted Solution

by:
byundt earned 500 total points
ID: 35165378
Try using a GoTo statement:
Application.GoTo Worksheets(Range("AC3").Value).Range("A3")

Brad
0
 

Author Comment

by:jmkbrown
ID: 35165427
This changed the selection to the correct cell, but the cell selection was off the screen.  
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 35165488
Try

Sheets(Range("AC3").Value).Activate
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question