View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike C[_5_] Mike C[_5_] is offline
external usenet poster
 
Posts: 24
Default Code to create worksheet names based on the values in the selectedrange


Is there any chance someone would know some code that allows me to
create new worksheets with the names of a selection of cells.

So, for example, if I selected the following cells:

Rice
Macaroni
Chicken
Hash Browns

I would like the macro to create four sheets by those names.

Any suggestions would be appreciated.