rickyckc
Active Member
- Joined
- Apr 1, 2004
- Messages
- 327
Hi all,
I have a workbook call Sales. In this workbook, I have a sheet call Sales Staff. In this sheet, I have a column of sales person's names. This list of sales names are grab from a database and is always not the same amount of people. I need a macro to do variable selection of the sales staff names, in column C, to help create a name call SalesStaff.
Currently what I have is manual selection...
[/code]
ActiveWorkbook.Names.Add Name:="SalesStaff", RefersToR1C1:= _
"='Sales Staff'!R2C3:R7C3"
I have a workbook call Sales. In this workbook, I have a sheet call Sales Staff. In this sheet, I have a column of sales person's names. This list of sales names are grab from a database and is always not the same amount of people. I need a macro to do variable selection of the sales staff names, in column C, to help create a name call SalesStaff.
Currently what I have is manual selection...
[/code]
ActiveWorkbook.Names.Add Name:="SalesStaff", RefersToR1C1:= _
"='Sales Staff'!R2C3:R7C3"
Code:
Thanks.
Best Regards,
Ricky