code 9 - subscript out of range error

C

Carl

I have a user who's getting a code 9 - subscript out of
range error on a workbooks(filename).activate command. No
other users have this problem, and all are using the same
version of excel...... anyone got any ideas? Please?

Carl
 
T

Tushar Mehta

It means that that particular workbook (the one identified by the
contents of filename) is not open.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

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

Microsoft 365 Activations, Users or Devices? 0
VBA code to link 2 drop down boxes in word 2010 0
Trouble Opening Outlook 365 1
VBA word change keys 0
Switching out of subscripting or superscripting 0
Automation of scanned file storage based on content 0
Creating a defined name's Refersto range 2
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0

Top