Subscript error from Selecting array of sheets

**coreytroy** · 12-10-2012, 12:46 AM

Please Login or Register  to view this content.

A numerical value is selected in C136 that makes visible a sheet tab witht he same numerical value.

The Sheets Array was working but since i added an option via a few checkboxes on a form to select a variable of range/s on the selected sheet as part of the PrintRange, it errors out now.

A part of the code to set the PrintRange from the form is below:

Please Login or Register  to view this content.

**AlphaFrog** · 12-10-2012, 01:06 AM

Try this to convert the numerical value to a string.

Sheets(Array("COVER", CStr(Sheet1.Range("C136").Value))).Select

**coreytroy** · 12-10-2012, 03:13 AM

Thanks Alpha, will give that a go tomorrow.

Subscript error from Selecting array of sheets

LinkBack

Thread Tools

Rate This Thread

Display

Subscript error from Selecting array of sheets

Re: Subscript error from Selecting array of sheets

Re: Subscript error from Selecting array of sheets

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions