View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Howard Howard is offline
external usenet poster
 
Posts: 536
Default "ElseIf c.Value = "X_Clear" Then" and "...Target.Cells.Count 1"don't work

Bravo, Claus, works fine.

Am I misunderstanding the line below about Target.Count?
I can still select more than one cell in the target range and the activecell of that selection will take an input. I guess its really is no big deal, just thought that would eliminate multiple selections.

Or Target.Count 1 Then Exit Sub

Thanks.
Howard