Hi erikkeith

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

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


"erikkeith via OfficeKB.com" <u13156@uwe wrote in message news:5fe2a77d1e9b6@uwe...
After finding a specific cell how can I set borders for the entire row? For
instance:

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

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200605/1