Rob said:
duplicate a table with the just values not formulas in the table so that I
don't have to readjust the formulas as when they are copied and pasted they
are often meaning less ie referring to the wrong cells

a) it's in the manual, Copy, Paste Special, Values.
b) wrong newsgroup, this is microsoft.public.excel.charting. try
microsoft.public.excel.misc

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.