View Single Post
  #1   Report Post  
David
 
Posts: n/a
Default SaveAs using two cells for filename

I'm trying to save a file with two cells of data to create the filename. Here
is the code:
Dim fname
With ActiveWorkbook
fname = .Worksheets(1).Range("B4").Value & .Range("E6") & ".xls"
..SaveAs fname
End With

I'm getting stopped on the fname line. I don't think I have the combination
right. Can you help?