OK, I would like to thank you all for making this such a valuable
resource.

Here is my question.

I need a macro that when I click on a command button it will save the
current worksheet (not the workbook) as a file based on the contents of
2 cells.

For example.

WorkSheet = 8

c9 = Name

d3 = Date

When you click on the button it will save Just the current worksheet
(8) as Name_Date.xls

Any help is greatly appreciated.

Thanks,

-T