VBA Help Requested - Bottom border across a table row to indicate a "threshold"

[rhcardenas]

Hi,

I'm new to VBA and could really use some help with a table formatting issue.

I've created a macro that creates a table from raw data and sorts it (high-to-low) by a column noting probability of success. Is there code that can be added to place a bottom border across the last row of data with a 50% success probability, to "separate" my table into probabilities above and below 50%?

So the final table would have:
Data (highest probability)
....
....
final row of data with 50% probability (BOTTOM BORDER)
remainder of data with <50% probability

Any help would be greatly appreciated. Thank you!