Here's an example, with border drawing.

I'm guessing, but if you're going to draw row borders then you might just
want to do:
For Each c in Range("range_name").EntireRow

Sub test()
Dim c As Range, lngRow As Long

For Each c In Range("range_name")
lngRow = c.Row
Rows(lngRow).Borders(xlEdgeBottom).Weight = xlMedium
Next c
End Sub


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Candy" wrote in message
...
I am trying to draw a border line. But before dwaring a
line, I need to get the row number first. Below is the
sample code. How can I get the row number of c?

For Each c In Range("range_name")
'get the row number of c
'draw a border line
next c

Thanks.