Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop excel formula
Hi,
I need to loop through A1, B1, C1, D1 - then do some IF checking Is there a FOR excel formula ? Or is there a better way ? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop excel formula
A more detailed explanation with example of before/after
-- Don Guillett SalesAid Software "magix" wrote in message ... Hi, I need to loop through A1, B1, C1, D1 - then do some IF checking Is there a FOR excel formula ? Or is there a better way ? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop excel formula
Dim myRng as range
dim myCell as range with worksheets("sheet9999") set myrng = .range("a1:D1") end with for each mycell in myrng.cells if mycell.value = "hi" then msgbox "It said hi!" else msgbox "No it didn't" end if next mycell magix wrote: Hi, I need to loop through A1, B1, C1, D1 - then do some IF checking Is there a FOR excel formula ? Or is there a better way ? Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA) | Excel Worksheet Functions | |||
Loop same formula for different columns? | Excel Programming | |||
excel loop in cell formula | Excel Programming | |||
Excel formula similar to a loop in Basic? | Excel Worksheet Functions | |||
Loop within Excel Formula? | Excel Programming |