Thread: If Then Statement in VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron Coderre[_5_] Ron Coderre[_5_] is offline
external usenet poster
  
Posts: 91
Default If Then Statement in VBA
Try this:

If Len(Range("n6").Value) = 3 Then
SendKeys "{F2}"
Else:
SendKeys "{F10}"
End If

Does that help?
--
Regards,
Ron

Reply With QuoteReply With Quote