David,

Thanks for your reply,

I have had a look at your macro from converting from xl to a webpage and
to be honest with you im very lost

Ive only just started to use Excel VBA


Basically what i require(pretty pretty pretty) please is


Select A1:Z43
save selected cells to a webpage directory path c:\
but file name needs to be what it is in Cell J4

many many many thanks if yiu can do this for me


Regards


Steve




David McRitchie wrote:
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