Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Cells
I need to select at the cells between the active cell and the
count cell in a do loop, have written as follows: Sub sort() Range("A100").Select Do While ActiveCell = ActiveCell.Offset(-1, 0) If ActiveCell = ActiveCell.Offset(-1, 0) Then ActiveCell.Offset(1, 6) = ActiveCell.Offset(1, 6) + 1 And ActiveCell.Offset(-1, 0).Select Loop Counter = ActiveCell.Offset(1, 6).Value + 1 Do Until Selection.Offset(Counter, 0) = aaaa If (Selection.Offset(Counter, 0)) = ActiveCell Then DON'T KNOW WHAT TO WRITE HERE With Selection.Offset(Counter, 0) End With End If Counter = Counter + 1 Loop End Sub can anyone HELP Thanks Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting multiple cells, I can't see the cells highlighted | Excel Discussion (Misc queries) | |||
How to change shade of cells when selecting multiple cells | Excel Discussion (Misc queries) | |||
By selecting cells adjacent to cells tally sheet | Excel Worksheet Functions | |||
Selecting Cells | Excel Worksheet Functions | |||
selecting cells | Excel Discussion (Misc queries) |