Hi,

I have a macro with these lines in it:

FName = Cells(2, 2).Value
ActiveWorkbook.SaveAs Filename:=FName

This works fine and saves the file as the value in the cell - however I want
to be able to call the file by the value in three cells and also add some
text, so the file name would look like:

"Reference (Cells (2,2).Value) Region (Cells (4,2).Value) Day (Cells
(5,2).value)"

Can anyone help??????


--
Cillian