know row index via Cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

--== Alain ==-- - 22 Jan 2007 12:40 GMT

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.

Reply to this Message

Don Guillett - 22 Jan 2007 14:19 GMT

myrow=cell.row
or
msgbox cell.row

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Hi,
>
[quoted text clipped - 13 lines]
> thx,
> Al.

Reply to this Message