You don't need to copy/paste anything to get this done. Simply assign
the range value to the range like so...

Selction.Value = Selection.Value

...so formulas are gone and their results are now constant values.

You also don't have to open any workbooks directly in Excel if you use
ADODB to update the values. Simply load each sheet (table) into a
recordset, edit the values, and then update the table in the file. For
more info (and examples)...

http://www.appspro.com/conference/Da...rogramming.zip

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion