PDA

View Full Version : Solved: ActiveCell rw,col



vzachin
09-29-2008, 06:28 AM
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

xld
09-29-2008, 06:33 AM
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
09-29-2008, 06:43 AM
hi bob,

thanks! that was too simple

zach