Hi,

I'm so new to VBA that I'm still at the recording macro stage then trying to
edit the macro! I have about 6 columns of data and about 1000 rows. I want
to put borders around those sections that should go together according to
Loop number. Here's a sample (sorted on the second column), I don't know how
well the columns will align after I send.

Loop 5J ANG data data data data
Loop 5J ANG data data data data
Loop 5J ANG data data data data

Loop 142 ANG data data data data

Loop 23 JES data data data data
Loop 23 JES data data data data

Above, I entered blank rows to separate the data to indicate the groups that
should have borders around them. In this example there would be three
separate borders around the three groups.

The criteria is that anytime there is a new Loop number, it begins a new
group that should be inside a common border.

Is this a simple job to write VBA that would border these groups in the 1000
rows according to the Loop criteria above? Any suggestions?

Many thanks,

Harold