kirbster
Board Regular
- Joined
- Feb 16, 2003
- Messages
- 52
Can I pick your brains on a macro issue I have.... this little thing here looksup a value in a table in sheet "tlm", creates a new sheet and then changes the name of the sheet to the cell value. All well and good, except it renames "tlm" with the first value it finds...
Sheets("tlm").Select
Range("A2").Select
Range(ActiveCell, ActiveCell.End(xlDown)).Select
For Each Cell In Selection
If Cell.Value Like "*Count*" Then Worksheets.Add
ActiveSheet.Name = Cell.Value
Next Cell
Sheets("tlm").Select
Range("A2").Select
Range(ActiveCell, ActiveCell.End(xlDown)).Select
For Each Cell In Selection
If Cell.Value Like "*Count*" Then Worksheets.Add
ActiveSheet.Name = Cell.Value
Next Cell