Border for row, 10 extra rows with borders

**anno1404** · 07-01-2011, 05:07 PM

Every week I have to do an excel sheet for 20 attorneys in the office.

There are 5 set columns. The number of rows for each attorney varies wildly, from 7 to 190.

I need to make a border for each of these rows, and an additional 10 rows below, which also have borders.

Ideal excel spreadsheet screenshot:

http://www.dead-rising-wiki.com/w/im...a_ten_rows.jpg

I see jasoncw's awesome solution to borders around cells with text. Problem is that many of these cells are empty, and it looks really bad if the empty cells have no borders.

Screenshot of empty cells that have no borders:

http://www.dead-rising-wiki.com/w/im...nformation.jpg

**watersev** · 07-01-2011, 05:16 PM

hi, anno1404, please check attachment, run code "test", hope this helps

**anno1404** · 07-02-2011, 01:14 AM

Originally Posted by watersev

hi, anno1404, please check attachment, run code "test", hope this helps

WOW thank you! My boss will be so happy.

Oh I forgot to mention that line A, B, C, F ALWAYS have info in them --that may have helped.

I miss Microsoft Word macros, much easier to program

Let me try it with a fake test example.... I will let you know if it works.

Yeah for watersev! If this works and you have a paypal account, I will drop in a couple of bucks for your trouble.

Grr... security level set to high.

http://gyazo.com/7ce3c333bde4cb44eca69e000fba03fb.png

So easy to fix. everyone should use gyazo.com one click and you have an image ready to paste on a webpage.

It WORKED, and it was SO short!:

PHP Code:


Sub test()
Range([a1], Cells(Rows.Count, "a").End(xlUp).Offset(10, 5)).Borders.LineStyle = xlContinuous
End Sub

I just emailed my boss.

private message me your paypal, and I will send you a little something to say thank you

**Mordred** · 07-02-2011, 01:50 AM

Hi Anno1404, if your workbook has sheets for each Attorney and therefore 20 or so sheets, I have modified watersevs excellent work to do it for each sheet.

Please Login or Register  to view this content.

**anno1404** · 07-02-2011, 05:05 AM

Originally Posted by Mordred

Hi Anno1404, if your workbook has sheets for each Attorney and therefore 20 or so sheets, I have modified watersevs excellent work to do it for each sheet.

Thank you, you two have been so very wonderful! In this tough economy with so few jobs, you have to make extra efforts at work, you guys have really helped me to keep feeding my family, and for that I am so grateful!