If Then Statement in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Can someone help with this statment...
 
Try this:

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

Does that help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If then and 2 cell values 5
Converting macros from Excel 2003 to Excel 2010 - Client Access dialog 3
Control of cell comments lsot in Office10 1
Running unix(putty) commands from vba 1
Edit a Cell 8
modeless dialog box 4
Code stops prematurely unless VB Editor open... 5
Need to send keystrokes to Internet Explorer? 1

Back
Top