Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code with and / or statement
I cannot get this to run the [ELK] macro when these 3 conditions are
met. It worked until I added the OR statement. I would really like it to check if the reference cells have numbers in them. Then if NOT run the ELK macro. If Sheet1.Range("b10").Value < "" Or Sheet1.Range("b19").Value < "" And Sheet1.Range("b11:aa11").Value = "" Then [ELK] Thanks for any help you can provide |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help Identifying code statement | Excel Discussion (Misc queries) | |||
If statement to replace #VALUE! code | Excel Worksheet Functions | |||
VBA code for IF statement with OR? | Excel Programming | |||
Worksheet code if-color-statement | Excel Programming | |||
Code doesn't go past first IF statement | Excel Programming |