Syntax must be incorrect for range reference

[rmunn]

The following sub to create and name wsheets results naming the new sheet with the value of "A9" only, but what I want to name the new sheet is "A9" + "B9". Where have I gone wrong?
Thanks.

Sub CreateWorksheets()
Dim newSheet As Worksheet, itemSheet As Worksheet
Dim cell As Object
Dim itemrange As String

Set itemSheet = Sheets("BIDFORM")

Application.ScreenUpdating = False
itemrange = "A9:B9:" & itemSheet.Range("A9").End(xlDown).Address
For Each cell In itemSheet.Range(itemrange)
If SheetExists(cell.Value) = False Then
Sheets.Add Before:=Sheets("BACK SHEET"), _
Type:="C:\Path\File"
Set newSheet = ActiveShee
newSheet.Name = cell.Value

End If
Next cell
Application.ScreenUpdating = True

End Sub

 

[wolverineb]

Change this

itemrange = "A9:B9:" & itemSheet.Range("A9").End(xlDown).Address

to this

itemrange = "A9:" & itemSheet.Range("A9").End(xlDown).Address

 

[rmunn]

Thanks for your quick response. I have already tried your suggestion, but the results are the same.

 

[wolverineb]

Maybe you mean to use xlToRight instead of xlDown?

 

[GeofW]

I didn't think you could name a sheet A9 + B9, but you can. I think you want to say

newSheet.Name = cell.Value & " + " & cell.offset(0,1).Value

 

[rmunn]

I tried GeofW's suggestion, and strangely the result was literally B9 + A9, meaning that the position of A9 and B9 were reversed, and the + also appeared in the result.

 

[wolverineb]

That's what your question says, literally.

Did you try the xlToRight thing?

 

[rmunn]

I did try xltoright, but the result was unchanged.

 

[wolverineb]

You should post your worksheet contents. Hard to tell what you really want (as you can see from GeofW's answer, which was logical but maybe not what you want).

 

[rmunn]

Perhaps I should have been more clear. What I am trying to do is to loop through cols A & B and combine those values at each row, with the resulting string being inserted as the name of the newly inserted sheet.
I have no problem with the inserting of the sheets, but can't get the name to include the combined value. When I run what I posted, the first sheet inserted was named A9, and the second sheet inserted was named B9, and so on down the columns.