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
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