Runtime error 9 subscript out of range 1

[vba317]

I have a workbook with 4 tabs in it. When I open the workbook template I have no issues. When I try to move to the next tab I get the Runtime error 9 subscript out of range error on the following code. Any help is appreciated.

Tom

Public goXl As Excel.Application 

goXl.Sheets(DenialBalGrid_RejCat).Select

 

[vba317]

I did a rename and copy and paste to drop the name of the sheet between the ().

 

[dhookom]

Are you suggesting you have resolved your issue?

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

copy and paste to drop the name of the sheet between the ().

goXl.Sheets([highlight]"[/highlight]DenialBalGrid_RejCat[highlight]"[/highlight]).Select

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[vba317]

Thanks skip