View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Candy[_2_] Candy[_2_] is offline
external usenet poster
 
Posts: 2
Default How to get the number of a row

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.