View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Sean Sean is offline
external usenet poster
 
Posts: 454
Default Rename a Sheet Q

I was thinking more of this, but I can't get it to run

i = Sheets.Count

If i = Sheets.Count = 22 Then
MsgBox "You have reached the maximum number of employees that you can
record, please contact xyz"
Exit Sub
End If