I Need This To Work For Tomorrow Please Help!!

CorpusSpongiosum · Mar 27th, 2002, 04:07 PM

Sheets("Sheet3").Activate
Range("B8").Select

This produces a runtime error 9
Subscript out of range

I wish to switch to sheet 3 (Message) and sect cell B8

Can anyone sort this

Thanks

Craig

BabyTiger · Mar 27th, 2002, 04:22 PM

Hi,

Does you active workbook contain a sheet with the name of "sheet3"

Joe Was · Mar 27th, 2002, 04:42 PM

Try:

Sheets("Sheet3").Select
Range("B8").Select

Hope this helps? JSW

keith · Mar 27th, 2002, 05:12 PM

use actual sheet name instead of "sheet3"

Worksheets("Message").Activate

Mark O'Brien · Mar 27th, 2002, 05:15 PM

"Sheet3" was the actual name in the original post. I supplied that code originally.

keith · Mar 27th, 2002, 05:31 PM

Ah ok - I gotcha..

on a hunch try

WorkSheet.

instead of

Sheets.

keith · Mar 27th, 2002, 05:32 PM

Worksheets.

I mean

Mar 27th, 2002, 05:15 PM	#5
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	"Sheet3" was the actual name in the original post. I supplied that code originally. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 27th, 2002, 04:07 PM	#1
CorpusSpongiosum New Member Join Date: Mar 2002 Posts: 9	Sheets("Sheet3").Activate Range("B8").Select This produces a runtime error 9 Subscript out of range I wish to switch to sheet 3 (Message) and sect cell B8 Can anyone sort this Thanks Craig

Mar 27th, 2002, 04:22 PM	#2
BabyTiger Board Regular Join Date: Mar 2002 Location: Wellington Posts: 104	Hi, Does you active workbook contain a sheet with the name of "sheet3"

Mar 27th, 2002, 04:42 PM	#3
Joe Was MrExcel MVP Join Date: Feb 2002 Location: Central Florida, USA Posts: 7,541	Try: Sheets("Sheet3").Select Range("B8").Select Hope this helps? JSW

Mar 27th, 2002, 05:12 PM	#4
keith Board Regular Join Date: Mar 2002 Posts: 88	use actual sheet name instead of "sheet3" Worksheets("Message").Activate

Mar 27th, 2002, 05:31 PM	#6
keith Board Regular Join Date: Mar 2002 Posts: 88	Ah ok - I gotcha.. on a hunch try WorkSheet. instead of Sheets.

Mar 27th, 2002, 05:32 PM	#7
keith Board Regular Join Date: Mar 2002 Posts: 88	Worksheets. I mean