Hehehe.

I saved my test workbooks first!

But it's fun to learn, huh?

Mike Fogleman wrote:

DUH!! No. I had opened the saved Book1 but opened Book2 with "New", not a
saved Book2.
Of course the code works exactly as Dave intended when Book2 is saved.
Ya gotta luv xl

Mike F
"Norman Jones" wrote in message
...
Hi Mike,

Did you have a workbook open which had previously been saved as Book2?

---
Regards,
Norman



"Mike Fogleman" wrote in message
...
What I am saying is that I do not have 'Hide extension for known file
types' selected, and the code error "Subscript out of Range" stopped at:

Set otherWks = Workbooks("book2.xls").Worksheets("sheet1")

So it did not work in my case.

Mike F
"KL" wrote in message
...
Hi Mike,

"Mike Fogleman" wrote in message
...
it would be better to include the extension for most users.

I'd say "it would be better...for all users" as the version "Book2.xls"
would work in both cases, while the "Book2" version requires the option
'Hide extension for known file types' to be selected.

Regards,
KL






--

Dave Peterson