Subscript out of range

  • Thread starter Thread starter Greg Glynn
  • Start date Start date
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
 
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.
 
Greg,
I assume the WB is actually "Backup Exec Check v2.0f.xls" ?

NickHK
 
You must log in or register to reply here.

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 in commandbutton_click 1
Subscript out of range 1
Creating a defined name's Refersto range 2
ERROR: subscript out of range 6
Error 9 - Subscript out of range 2
Runtime Error '9': Subscript Out Of Range 6
subscript out of range 2
runtime error 9 -- subscript out of range 12

Back
Top