Thread
:
create & name multiple worksheets
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
Posts: n/a
create & name multiple worksheets
like this?
Sub newsheets()
For i = 4 To 24
Sheets.Add
ActiveSheet.Name = i
Next
End Sub
--
Don Guillett
SalesAid Software
"OrlaH" wrote in message
...
Hi:
I have a row of 20 numbers.
I want to create a worksheet for each number and name the worksheet after
that number.
I have a little exposure to macros.
OrlaH
Reply With Quote