Subscript out of range

G

Greg Glynn

Can anyone tell me why this gets a "Subscript out of Range" error?

MsgBox Workbooks("Backup Exec Check
v2.0f").Sheets("BackupEXEC").Range(Cells(22, 1)).Value

The workbook and sheet DO exist.

(It's driving me insane.)

Regards

Greg
 
S

Stopher

Greg said:
Can anyone tell me why this gets a "Subscript out of Range" error?

MsgBox Workbooks("Backup Exec Check
v2.0f").Sheets("BackupEXEC").Range(Cells(22, 1)).Value

The workbook and sheet DO exist.

(It's driving me insane.)

Regards

Greg
Click to expand...

either take out the range or cell and make it one or the other. I would
guess range seeing you have a cell reference in there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ERROR: subscript out of range 6
error subscript out of range in commandbutton_click 1
subscript out of range 2
Runtime Error '9': Subscript Out Of Range 6
Subscript out of range 26
Error 9 - Subscript out of range 2
Subscript out of range 1
Run time error 9 (Subscript Out Of Range) 2

Top