Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Put a Line on the bottom of a group of cells

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    John G
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a routine that loops through a database and picks out data and puts it on another sheet in columns 1 to 5 in the same row. It pulls data from the database file from 1 to 17 records before moving to the next row (or record). I want to put a line on the bottom of the cell of the last record of the group in the columns 1 to 5. The data in these columns is not always filled. I'm unsure how to format the cells with line at the bottom of the cell. Does anyone have some good advice?

    John

  2. #2
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes sir, right-click on the cell, choose 'format cells...' Click on the 'Border' tab. Select your line weight on the right and click beneath the text. Then hit the ok button.

    HTH. Cheers,
    Nate

  3. #3
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ou, en vba monsieur:

    With Selection.Borders(xlEdgeBottom)
    .LineStyle = xlContinuous
    .Weight = xlThin
    End With

    Cheers, Nate

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •