Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A way to simplify this please
Can someone suggest a way to Simplify the following code.
If Cells(6, ccx) = Cells(3, 19) Or Cells(6, ccx) = Cells(3, 20) Or Cells(6, ccx) = Cells(3, 21) Or Cells(6, ccx) = Cells(3, 22) Or Cells(6, ccx) = Cells(3, 23) Or Cells(6, ccx) = Cells(3, 24) Or Cells(6, ccx) = Cells(3, 25) Or Cells(6, ccx) = Cells(3, 26) Or Cells(6, ccx) = Cells(3, 27) Then Cells(6, ccx).ClearContents End If Thank you Larry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to simplify this... | Excel Worksheet Functions | |||
please help simplify | Excel Programming | |||
please help simplify | Excel Programming | |||
please help simplify | Excel Programming | |||
Simplify | Excel Programming |