Wrong # arguments or invalid property assignment

[willydude]

Wsheet is the activesheet name.
SalesPeople is the sheet that has the salespeople's names.

I want to name a cell on the active sheet (i.e Branch8) _
using the activesheet's name and the salespersons _
name from the worksheet "SalesPeople".
Example: "JoeBranch8"

None of the following work.

.Offset(0, 11).Name = Worksheets("SalesPeople").Range("B1").Value & " " & Wsheet

.Offset(0, 11).Name = Worksheets("SalesPeople").Range("B1").Value & "!" & Wsheet

.Offset(0, 11).Name = Worksheets("SalesPeople").Range("B1") & Wsheet

 

[PHV]

Perhaps this ?
.Offset(0, 11).Name = Worksheets("SalesPeople").Range("B1") & Wsheet.Name

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[willydude]

Invalid qualifier on wSheet. But I already have

Dim Wsheet as String
Wsheet = ActiveSheet.Name

Doesn't this handle any qualifying for the sheet name?

Also tried

& "!" & Wsheet.Name

 

[PHV]

What is the value of Worksheets("SalesPeople").Range("B1") ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[willydude]

B1 is "Joe" w/o quotes
B2 is "Bob"
B9 is "HouseAccount"
B18 is "Joe AI