How would I add a border to a specific row depending on the data? Also how do I add this line without knowing the row and the column numbers but add the line for the value that is being searched for? I would assume I would search with the value I am looking for. I have already got it where you put border around the data that I have copied. After I pasted the data I named my selection...so I do have a selection name. Here is an test example:

Size V4 V6 V10

A 10 30 40
A1 10 20 60
B 10 30 40
B1 10 30 40
C 10 20 40
C1 10 20 40

I want to be able to put a line after the A1,B1,C1. The line will be for the whole row.

Hope I am making sense.

Thanks
Kimberly