VBA - How to refer to a sheet with quotes (" ") in the sheet name....

[ValpoMan]

I am trying to select a worksheet in VBA that has quotes in the sheet name....for example the Sheet Name is "Postage Report" so I am trying to type the following in VBA:

Sheets(""Postage Report"").Select

I keep getting errors....

Any suggestions?

Thanks!

 

[Marcelo Branco]

Try

Sheets("""Postage Report""").Select

or easier

Sheets(Chr(34) & "Postage Report" & Chr(34)).Select

M.

 

[Smitty]

Question: why would you have quotes in the sheet name in the first place, especially when it doesn't seem necessary?

 

[ValpoMan]

Question: why would you have quotes in the sheet name in the first place, especially when it doesn't seem necessary?

That is how the file comes to me.....I have asked them several times to remove them but they don't want to play ball....lol....

 

[ValpoMan]

Works! Thank you so much!

Try

Sheets("""Postage Report""").Select

or easier

Sheets(Chr(34) & "Postage Report" & Chr(34)).Select

M.

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.