How to get the number of a row

C

Candy

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

Chip Pearson

Candy,

The Row property of the range will return row number of that
cell. E.g,

Dim R As Long
For Each c In Range("range_name")
R = c.Row
'draw a border line
next c


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
B

Bob Phillips

Hi Candy,

For Each c In Range("range_name")
iRow = c.Row
next c


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
R

Rob van Gelder

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
 
Top