Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? -- stub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Step through cells in a selected range | Excel Programming | |||
Step through cells in a selected range | Excel Programming | |||
Set Range Using Selected Cells | Excel Programming | |||
Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
max/min of a selected range of cells | Excel Programming |