Hi Steve,
What part do you need help with.

Does this page help, you would need to modify or add
a front end to loop through sheets or whatever you doing
but the macro will create an HTML page for very simple
tables, with some cell merging, one color font and one
background color for cell.

The actual purpose was to
extract the table and put it into my own web page.
Excel to HTML conversions
http://www.mvps.org/dmcritchie/excel/xl2html.htm

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"steve" wrote in message ...
Dear All,


I have a worksheet and various data is written to this sheet about 300
times using a series of macros

i need to save each of the sheets(300 ish) as webpages

Cell J4 is the filename to which i need the file saves as


Can anyone please help me


Many many thanks in advance




Steve