Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to run the following statement... which works fine for whatever
my N6 value is. however, I would like it to run the same way if either cell N6 or O6 has the conditional properties in the statment. Do I need to run some sort of loop? Can I put in an "OR" so that ... If Len(Range("n6") OR ("o6").Value) = 3 Then...... I think I need to run a loop that will run, but I have only worked with VBA for a couple of weeks so I am not exactly sure. If Len(Range("n6").Value) = 3 Then SendKeys "{TAB}" SendKeys "{TAB}" SendKeys "{TAB}" SendKeys "{TAB}" SendKeys "{TAB}" ElseIf (Range("n6").Value) = "fedl" Then SendKeys "{TAB}" SendKeys "{TAB}" SendKeys "{TAB}" Else: SendKeys "{TAB}" SendKeys "{TAB}" End If Thanks for the help!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLookup multiple values - sum returned values into single cell | Excel Worksheet Functions | |||
Copy values from a cell based on values of another cell | Excel Discussion (Misc queries) | |||
How to assign values to a cell based on values in another cell? | Excel Worksheet Functions | |||
Search/Filter to find values in another range based on two cell values | Excel Programming |