I have a excel sheet that compares to columns of numbers for differences
and highlights them, is there any way to run a scipt that will
automatically make a new excel sheet and import the different numbers
into it.

Thanks for any help.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Worksheets.Add

will add a worksheet

Beyond that, it would be difficult to provide sample code. If you are using
code to do your highlighting, then just modify the code to copy the cells to
the new worksheet as well.

--
Regards,
Tom Ogilvy

"bt707" wrote in message
...
I have a excel sheet that compares to columns of numbers for differences
and highlights them, is there any way to run a scipt that will
automatically make a new excel sheet and import the different numbers
into it.

Thanks for any help.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/