HunterN
Active Member
- Joined
- Mar 19, 2002
- Messages
- 479
Hi,
I have the following columns A, B and C.
A B C
123 b x
455 b x
789 b x
672 b x
143 b x
---------------------------
Say something is in Col A (but not on every row). But in some instances
there is data in Col A one row after the next. How do I move from one
row to the next ( in Col A ) and not jump over any rows with data.
This is the code I currently have:
Do While LoopRw <= final_Row
Call ReCalculate_Location
If LoopRw < final_Row Then
Selection.End(xlDown).Select
LoopRw = ActiveCell.Row
Else
LoopRw = LoopRw + 1
End If
Loop
My problem is the Selection.End(xlDown).Select line. When the above code runs it skips over the row with 789 in the column. Watching it in debug it jumps over one (or more) and go to the bottom row of a group. So the Call ReCalculate_Location gets skipped for some rows.
I hope someone can reduplicate this problem and help me out here!
Thanks, Nancy
I have the following columns A, B and C.
A B C
123 b x
455 b x
789 b x
672 b x
143 b x
---------------------------
Say something is in Col A (but not on every row). But in some instances
there is data in Col A one row after the next. How do I move from one
row to the next ( in Col A ) and not jump over any rows with data.
This is the code I currently have:
Do While LoopRw <= final_Row
Call ReCalculate_Location
If LoopRw < final_Row Then
Selection.End(xlDown).Select
LoopRw = ActiveCell.Row
Else
LoopRw = LoopRw + 1
End If
Loop
My problem is the Selection.End(xlDown).Select line. When the above code runs it skips over the row with 789 in the column. Watching it in debug it jumps over one (or more) and go to the bottom row of a group. So the Call ReCalculate_Location gets skipped for some rows.
I hope someone can reduplicate this problem and help me out here!
Thanks, Nancy