Solved: ActiveCell rw,col

[vzachin]

hi,

i have a general question.
with the following code, i predefine my rw & col.the problem i have is that the row & column may change.
i want to evoke the macro from the active cell.
how do i code the row & col based on the active cell
i will always have 5 columns. and rows may be 5 or 6 rows.

rw = 1
Do
rw = rw + 1
For i = 7 To 11
mydat = Cells(rw, i)
'do stuff
Next i
Loop Until rw = 6


thanks
zach

[Bob Phillips]

rw = ActiveCell.Row
Do
rw = rw + 1
For i = 7 To 11
mydat = Cells(rw, i)
'do stuff
Next i
Loop Until rw = 6

[vzachin]

hi bob,

thanks! that was too simple

zach