compile error: syntax error

[Pookiemeister]

Range("'Exhibit " & """I"" "'!$C$3:$D$3").clearcontents

I have a worksheet called Exhibit "I" and inside that worksheet I have various ranges that I would like cleared when this workbook opens. This is just one of many ranges I would like cleared. The above code returns a syntax error. How can I fix this issue. Thank You

 

[MARK858]

Maybe...

Worksheets("Exhibit " & """I""" & " ").Range("C3:D3").ClearContents

Based on your other post

 

[Pookiemeister]

After turning on my Auto Syntax Check editor, it now displays "Compile error: Expected: list serparator or )" for the above code. I'm pretty sure it has something to do with the way the sheet is named but I have no idea how to fix this.
The code below has no problems with clearing the Range's content.

Range("'page 2'!$C$5:$D$5").ClearContents

Any help would be greatly appreciated on fixing this issue. Thank you.

 

[Pookiemeister]

Thank You Mark858. That worked.