s0nicstang
Board Regular
- Joined
- Jan 7, 2009
- Messages
- 73
I want to add new worksheets and name them based on the values of what i have in Col C on my main Tab.
This is what i came up with which will insert only the 1st one on the list?
With Sheets("Main")
Lr = .Range("C5").End(xlDown).Row
For i = 5 To Lr
Set ws = Range("C" & i)
Sheets("Main").Select
Worksheets.Add().Name = ws
Next i
This is what i came up with which will insert only the 1st one on the list?
With Sheets("Main")
Lr = .Range("C5").End(xlDown).Row
For i = 5 To Lr
Set ws = Range("C" & i)
Sheets("Main").Select
Worksheets.Add().Name = ws
Next i