subscript out of range error

[alexcrofut]

Hello,
I keep getting an error message when running the following code.
I am not sure why, but I keep getting a "Run-Time error '9': Subscript out of range" error message

Please Login or Register  to view this content.

Any idea why?

[Richard Buttrey]

Perhaps because when the workbook opens the "NIC" sheet isn't the Active sheet.

On which line do you get the error?

[alexcrofut]

The error pops up twice, On opening the first file and on activating the second window

I changed the code to:

Please Login or Register  to view this content.

and now I get a "Application-defined or object-defined error" on selecting the NIC sheet

[Richard Buttrey]

Hi

Is there in fact an "NIC" sheet, and is it visible when the workbook is opened?