know row index via Cell
 

Hi,

i have the following code :

For Each cell In ThisWorkbook.Worksheets("Programs").Range("C2:C" &
(MaxRecords + 1))

....
// detect row_number
....

Next cell

how can i get the row index (or number of the row) via "cell" ?

thx,
Al.

know row index via Cell
 

myrow=cell.row
or
msgbox cell.row

--
Don Guillett
SalesAid Software

"--== Alain ==--" wrote in message
...
Hi,

i have the following code :

For Each cell In ThisWorkbook.Worksheets("Programs").Range("C2:C" &
(MaxRecords + 1))

...
// detect row_number
...

Next cell

how can i get the row index (or number of the row) via "cell" ?

thx,
Al.