[SOLVED] visual basic command identify a worksheet in a workbook

A staff member produced an insert macro using visual basic editor in excel
When I attempt to insert a sheet, the macro always selects the first sheet
of a multipal book. The following command has been used.
Sheets ("Command Page").Select

How can I identify a specfic sheet in a workbook

perhaps

to get the last sheet as an example.

With thisworkbook
.Worksheets(.Worksheets.count).Select
End With

or you can specify a specific sheet,

Worksheets("MyNewSheet").Select

but that is what you are already doing.

--
Regards,
Tom Ogilvy

"F.C" <[email protected]> wrote in message
news:[email protected]...
> A staff member produced an insert macro using visual basic editor in excel
> When I attempt to insert a sheet, the macro always selects the first sheet
> of a multipal book. The following command has been used.
> Sheets ("Command Page").Select
>
> How can I identify a specfic sheet in a workbook

Dear Tom


I ended up doing the following

Worksheets("Export").Select

Thank you for your help

Kind Regards
Frank



"Tom Ogilvy" wrote:

> perhaps
>
> to get the last sheet as an example.
>
> With thisworkbook
> .Worksheets(.Worksheets.count).Select
> End With
>
> or you can specify a specific sheet,
>
> Worksheets("MyNewSheet").Select
>
> but that is what you are already doing.
>
> --
> Regards,
> Tom Ogilvy
>
> "F.C" <[email protected]> wrote in message
> news:[email protected]...
> > A staff member produced an insert macro using visual basic editor in excel
> > When I attempt to insert a sheet, the macro always selects the first sheet
> > of a multipal book. The following command has been used.
> > Sheets ("Command Page").Select
> >
> > How can I identify a specfic sheet in a workbook
>
>
>