You select the row with your code so if you record a macro you can add this to your code

Cells.Find(What:="Totals", After:=ActiveCell, LookIn:=xlFormulas _
, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).EntireRow.Activate

Selection.Borders(xlEdgeLeft).LineStyle = xlContinuous
Selection.Borders(xlEdgeTop).LineStyle = xlContinuous
Selection.Borders(xlEdgeBottom).LineStyle = xlContinuous
Selection.Borders(xlEdgeRight).LineStyle = xlContinuous


--
Regards Ron de Bruin
http://www.rondebruin.nl


"erikkeith via OfficeKB.com" <u13156@uwe wrote in message news:5fe3c2428134c@uwe...
You must not have understood my question. I want to be able to set up the
borders for cells A:O on the row that the "find" found what I was looking for.
....that being "Totals"

Ron de Bruin wrote:
Hi erikkeith

Record a macro when you do this en then look at the code

After finding a specific cell how can I set borders for the entire row? For
instance:
[quoted text clipped - 4 lines]

I try to set up the borders for that entire row but it is not working. Help?

--
Message posted via http://www.officekb.com