I Need This To Work For Tomorrow Please Help!!

[CorpusSpongiosum]

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]

Hi,

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

 

[Joe Was]

Try:

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

Hope this helps? JSW

 

[keith]

use actual sheet name instead of "sheet3"

Worksheets("Message").Activate

 

[Mark O'Brien]

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

 

[keith]

Ah ok - I gotcha..

on a hunch try

WorkSheet.

instead of

Sheets.

 

[keith]

Worksheets.

I mean