Thanks.
Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]
On Tue, 2 Feb 2010 06:46:06 -0800 (PST), Phil Hibbs
wrote:
joel wrote:
Another method is to write a macro that saves the VBA code to a BAS
file and then read the BAS file into the 2nd workbook. Chip Pearson has
good instruction on doing this at his website
'Programming In The VBA Editor'
(http://www.cpearson.com/excel/vbe.aspx)
Best web page ever! Thanks.
Phil Hibbs.