As long as the values in the cell do not contain forbidden characters, you
could simply reference the cell when saving the file using
range("cell_containing_name").value
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


" wrote:

I have a macro to save a sheet as an htm file. I can specify a name
for the file. Is there a way to use the contents of a cell for the
file name? Thanks for any and all help.