hi
i am trying to use a variable to open a new worksheet ıf there ıs a value ın that cell and name ıt as that variable
thanks
hi
i am trying to use a variable to open a new worksheet ıf there ıs a value ın that cell and name ıt as that variable
thanks
Try:
IF sheets("sheetx").range("A?").value<>"" then
ActiveWorkbook.SaveAs _
Filename:=sheets("sheetx").range("A?").value, _
etc.
ELSE
something...
END IF
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks