Hi,
I have a excel sheet with names in range (A2:A11).
1. I'm looking for a vb script that creates a new excel sheet on my desktop.
2. The worksheets in the workbook should be named from the range i have in the excel.
3. Its not defined that i have 10 names in the range each time, so the macro should count and create the worksheets & should not create extra worksheets.
Appreciate your help in advance.
I have a excel sheet with names in range (A2:A11).
1. I'm looking for a vb script that creates a new excel sheet on my desktop.
2. The worksheets in the workbook should be named from the range i have in the excel.
3. Its not defined that i have 10 names in the range each time, so the macro should count and create the worksheets & should not create extra worksheets.
Appreciate your help in advance.