View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Incidental Incidental is offline
external usenet poster
 
Posts: 226
Default VB code to save worksheet as...

Hi

you could try adding the cells refs to a string then use that as your
saveas name.

Option Explicit
Dim fName As String

Private Sub CommandButton1_Click()
fName = [j3] & [u3]
ActiveWorkbook.SaveAs Filename:=fName
End Sub

hope this is of some help

S