| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IFELSE question, as it applies to multiple cells
Hi all
I have this code working for one cell If Range("h1") = 3 Then If Range("f19") = "" Then Range("b52") = "" ElseIf Range("f19") = "149028" Then Range("b52") = "" Else: Range("B52") = "ERROR" End If However, the same condition has to exist for cells F20-F38 - in other words, if H1=3, any, some or all of those cells (F20-F38) can either be null or contain "149028", or an error will display in cell B52. I cannot for the life of me figure out how to include the additional cells. Can someone give me a hint? I have tried everything I can think of and nothing seems to work. Any assistance much appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting only applies to part of cell text | Excel Worksheet Functions | |||
| this also applies to Microsoft Word, both Office 2003 | Excel Discussion (Misc queries) | |||
| criteria applies to a range of dates. | Excel Discussion (Misc queries) | |||
| Sum of data where a condition applies | Excel Discussion (Misc queries) | |||
| How to specify which cells/columns macro applies to? | Excel Worksheet Functions | |||
Threaded Mode
