S
stub
using windows XP; created macro to look at each cell in a one column range.
named range. dim. variables. selected worksheet.selected named range.
created for next cell in seledction. see following
Sheets("Sheet2").Select
Range("I16.I45").Select
For Each cell In Selection
If ActiveCell.Value = False Then
ActiveCell.Offset(0, -2).Value = ActiveCell.Offset(0, -2).Value +
Range("step").Value
End If
Next cell
the offset value is increased until the active cell is not false but the
program does not loop to the next cell in the range. how do i correct?
named range. dim. variables. selected worksheet.selected named range.
created for next cell in seledction. see following
Sheets("Sheet2").Select
Range("I16.I45").Select
For Each cell In Selection
If ActiveCell.Value = False Then
ActiveCell.Offset(0, -2).Value = ActiveCell.Offset(0, -2).Value +
Range("step").Value
End If
Next cell
the offset value is increased until the active cell is not false but the
program does not loop to the next cell in the range. how do i correct?