Try this code and adapt to suit your needs:
NB code assumes both workbooks are open and that the code is being run while book1 is the active book.
"I have a plan so cunning, you could put a tail on it and call it a Weasel." EB
Eagles may soar, but Weasels don't get sucked into jet engines.
Templates and Calculators
The Way of the Weasel
Download Ivan & Colo's HTML Maker Here
101 Excel Hacks - Great New Book
Huge Savings on Excel Training
There are currently 1 users browsing this thread. (0 members and 1 guests)