I am trying to save a new worksheet using a value in my sourcesheet and the tab name of the sourcesheet. My code works well if I just use the value, but as soon as I add the sourcesheet name code, I get an error. Can you help?
Dim Name as String
Dim sourcesheet As Variant
Name = sourcesheet.range("A1").Value & " " & sourcesheet.Name 'sourcesheet.Name is where my code isn't working. If I just do the A1 value it works