View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Reed[_3_] Reed[_3_] is offline
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