Define sheet name then select sheet

's Computer Specifications

Hiya,

I've typed the name of the sheet I want to go to in a cell in excel & used
the macro to define it, but then I can't seem to get the code right for using
that definition to activate the sheet.

sheet_name = ActiveCell.Value
Sheet sheet_name.Select (I've tried lots of different ways of writing this...)

Can anyone help?

Thanks
merry_fay

's Computer Specifications

Try

ThisWorkbook.Sheets(sheet_name).Select

--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"merry_fay" <(E-Mail Removed)> wrote in message
news:8F452ED2-C617-4131-91B3-(E-Mail Removed)...
> Hiya,
>
> I've typed the name of the sheet I want to go to in a cell in excel & used
> the macro to define it, but then I can't seem to get the code right for
> using
> that definition to activate the sheet.
>
> sheet_name = ActiveCell.Value
> Sheet sheet_name.Select (I've tried lots of different ways of writing
> this...)
>
> Can anyone help?
>
> Thanks
> merry_fay

's Computer Specifications

Hi,

Just try :

Dim sheet_name As String
sheet_name = ActiveCell.Value
Sheets(sheet_name).Select

HTH

's Computer Specifications

Sub selectsheetfromcellvalue()
Sheets(ActiveCell.Value).Select
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"merry_fay" <(E-Mail Removed)> wrote in message
news:8F452ED2-C617-4131-91B3-(E-Mail Removed)...
> Hiya,
>
> I've typed the name of the sheet I want to go to in a cell in excel & used
> the macro to define it, but then I can't seem to get the code right for
> using
> that definition to activate the sheet.
>
> sheet_name = ActiveCell.Value
> Sheet sheet_name.Select (I've tried lots of different ways of writing
> this...)
>
> Can anyone help?
>
> Thanks
> merry_fay

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What is the difference between 'Select' a sheet and 'Activate' a sheet	RJQMAN	Microsoft Excel Programming	9	30th Oct 2010 05:22 AM
Select a Sheet Issue in VBA on a very hidden sheet - fails	christopher ward	Microsoft Excel Programming	6	21st Jul 2009 01:30 PM
Select sheet, Pause till Enter pressed, return to previous sheet	Russ3Z	Microsoft Excel Programming	1	12th Jun 2007 11:06 PM
How do I select price from sheet.b where sheet.a part no = sheet.b	=?Utf-8?B?U29ubnk=?=	Microsoft Excel Worksheet Functions	4	4th Apr 2006 05:08 PM
Use Sheet CodeNames to Select Sheet in Different Workbook	Randy	Microsoft Excel Misc	1	10th Jun 2005 12:17 AM