View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Luc Ferrari Luc Ferrari is offline
external usenet poster
 
Posts: 3
Default Create a new worksheet (excel 2003) if one or more cells in a range is not empty

I want to create a new "tab, worksheet or whatever you call it " (in excel
2003) if one or more cells in a range contain a value.
The code starts after i hit a "button".

And name the sheet after the value of the cell left of the first cell of
that range.

I have no clue in how to program this.
Can someone provide me the code for this....


Thanks for your help

Luc