Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get the number of a row
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 "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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get the number of a row
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) "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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get the number of a row
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif number is greater than a number but less than another number | Excel Discussion (Misc queries) | |||
How can I click on a telephone number in an Excel 2002 spreadsheet, and have the number dialed? | Excel Discussion (Misc queries) | |||
Easy Reading - large number minus small number | New Users to Excel | |||
How to calculate number of occurencies of a specific number number | Excel Discussion (Misc queries) | |||
Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions |