LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Automatic Borders

Hi,

I have 55 workbooks and all need to be formatted exactly the same, but have
different ammounts of data. The First line of data is at Row 10 and I need
a border every 4 rows after Row 10 until the end. The total number of rows
is not necessarily a multiple of 4, so at the data at the end may only be 3
rows, and the border needs to be after the last row. How can I accomplish
this?

Thanks,

Mike

10
-------- border
11
12
13
14
-------- border
15
16
17
18
-------- border
19
-------- border


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
borders mhenley5 Excel Discussion (Misc queries) 2 May 5th 09 11:09 PM
Borders Derek Koehler Excel Discussion (Misc queries) 1 March 12th 09 02:19 PM
Borders anita Excel Worksheet Functions 6 September 15th 06 01:15 PM
borders Brush Prairie Excel Discussion (Misc queries) 0 August 23rd 05 02:57 AM
Borders Alan Excel Programming 3 November 10th 04 06:40 PM


All times are GMT +1. The time now is 06:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"