I copy and paste a web page into excel in sheet1
The page I import changes every day and is different
in size , I delete all data in sheet 1 and copy and paste
the new web page in sheet 1.
I cannot use "clear contents " as the new web page size is
different to the last web page.
I have all my work sheet function formulas to extract data
from sheet 1 in sheet 2.When I delete sheet 1, I get #REF!
errors in all my formulas in sheet 2.
Is ther a way to over come this?
I would like a work sheet function if there is one

Thanks for all reply's

regards Bill
--
bill gras