View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rich Mogy Rich Mogy is offline
external usenet poster
 
Posts: 19
Default Naming work sheet the name as sub-routine that creates it

I have a macro that I'm trying to create several work sheets, and then put
information retrieved from a SQL database. I would like the name of each
worksheet to be the same as the sub routine that created it. Is this
possible through the code --

sub myworksheet
worksheets.add
worksheets.name(x) where x is the name of the sub
end sub

Thanks in advance.

Rich Mogy