SaveAs

Hello Jim, and welcome to the forum.

When I record the steps to save a range as a web page (html), I get the following code:

With ActiveWorkbook.PublishObjects.Add(xlSourceRange, _
        "C:\Documents and Settings\Paul\Desktop\test.htm", "Sheet1", "$B$4:$C$16", _
        xlHtmlStatic, "Demo2(1)_22030", "")
        .Publish (True)
        .AutoRepublish = False
    End With

This is in Excel 2007, and I'm not sure if it has changed from 2003. Try recording it and see!