Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The basics of my code a
For each cell in Range("A1, B3, C5") If cell.value=x Then 'change to this value Else 'change to another value End If Next Cell But this only seems to work on the first cell. What I am trying to do is iterate through small group of cells (not necessarily in an array) to see whether the date in each is a good business day. If not, the code replaces the date with a string variable. Can you not use a For Each Loop for this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
loop in range | Excel Programming | |||
Loop in a Range | Excel Programming | |||
Loop through Range and Cut and Paste | Excel Programming | |||
Loop through a range | Excel Programming | |||
Increasing a range in a loop | Excel Programming |