How to select a sheet in VBA when sheet name has parentheses in it

  • Thread starter Thread starter SJ
  • Start date Start date
S

SJ

Hi there,
I am trying to select a sheet using

xlBook.Sheets("AP-STT(U)").Select

as you can see the sheet name has parentheses in it, so excel gives me a
"Subscript out of range" error.

If I select any other sheet that doesn't contain parenthesis then it works
fine.

Any ideas on how I should be going about this.

Yes, I am a newbie to excel object model.

oh yeah, Office XP I think.
 
Check your spelling (any leading/trailing/embedded spaces?)

And if xlBook isn't the active workbook, you'd get a different error.

If you're going to use .select, make sure you activate that workbook first.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get Name of Sheet to use in Macro 11
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Formula to consolidate 130 sheets into a summary sheet 6
Custom Reporting Across Sheets 1
How to list cells from two sheets that has different values in theirneighboring column? 8
VBA Macro - Copying specific data to different sheets in a workbookand linking the InputBox to a com 7
Excel2007 | I want to create a pivotTable from a different data, and different sheets 0
Macro to copy value in field and insert it into filter 2

Back
Top