Problem in activating a sheet

[Neeleshwar Thakur]

Hi all,

In my excel application I am adding a sheet after the 4th
sheet,once i check the check box On the First Sheet,but
somehow i am not able to navigate to another sheet.

I know this may be a simple one but i tried in different
options but so far no luck.

It would be great if somebody can help me.

Thanks
Neelesh

 

[Chip Pearson]

Needles,

Try something like

Worksheets(5).Select


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com