jmkbrown
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.
My current code is:
Sheets(Range("AC3").Value)
Range("A3").Select
But this does not change the cell selection for the new sheet.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try
Sheets(Range("AC3").Value) .Activate
Sheets(Range("AC3").Value)
ASKER