Hello

I'm using a UserForm to gather information.

Two new sheet will be created and named using a field gathered from the UserForm. Ranges will be created using part of the name.

I tried the following to name the new sheet yet receive a Run-time error; any suggestions? If possible, could someone explain the principle for using the ReportName as a variable as I need to use it naming ranges on the sheets.

Sheets.Add.Name = ReportName.Text
and

Sheets.Add.Name = &"Temp_"&ReportName.Text