Link to home
Start Free TrialLog in
Avatar of jmkbrown
jmkbrownFlag for United States of America

asked on

Trying to select cell "A3" after selecting a sheet

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.
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jmkbrown

ASKER

This changed the selection to the correct cell, but the cell selection was off the screen.  
Try

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