Line Numbers needed

**covey9257** · 11-07-2007, 11:02 AM

Hi. I have a form that needs line numbers in column A for only the rows that have data in them; if B6 <> "". I'm using Excel 2002 and a stored procedure to bring in the data from a PSql database. The data actually starts on row 6 in sheet1, so I can't just use the grid row numbers. I've tried everything I can think of to just add an integer to populate the line number column, but, when I do it I get 65536 rows populated instead of the 237 that I need. I know there is probably a very simple way to do this, but I can't seem to find it. I'm an old Cobol programmer and this has me stumped.

Thanks for any help

Cathy

**royUK** · 11-07-2007, 11:28 AM

maybe this will help

Dim rng    As Range
    Dim cl     As Range

    Set rng = Range(Cells(6, 2), Cells(Rows.Count, 2).End(xlUp))
    For Each cl In rng
        If Not IsEmpty(cl) Then cl.Offset(0, -1).Value = cl.Row - 5
    Next cl

**mikerickson** · 11-07-2007, 11:32 AM

would putting =COUNTA(B$5:B6) in A6 and filling down do what you want?

**covey9257** · 11-07-2007, 11:43 AM

Thanks Roy. It works!!! I really appreciate the help. And Mike, I tried that and it worked great until I initialized the cells with a clear contents for the next query, then it wiped out the Count formula.

Thanks again to both of you for your fast replys!!
Cathy

Line Numbers needed

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Line Numbers needed

Thanks!!!

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions