proper Subscript out of range

[Coder]

The folloing code works perflectly in 2003 but now under 2007 the first ".find" statement give me a subscript out of range error message. Whats going on? The code still looks valid to me.

Please Login or Register  to view this content.

This is just an excerpt so you'll have to take my word that wbNewWorkBook is a valid workbook object.

[Chance2]

Coder,

If I run this code as is in 2003 or 2007 I get the subscript out of range error message. However, if I change the line from this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

it works for me (or at least for this snipit of code, no errors).

[Coder]

Ah yes, thank you, that does it. I've no idea why LookIn worked before but there you go. I should of twigged really as I looked up XlPart in the object browser and it came up under the XlLookAt class... that's what you get working late on a Friday I guess.