Posted to microsoft.public.excel.programming

erikkeith via OfficeKB.com erikkeith via OfficeKB.com is offline

external usenet poster

Posts: 31

Border help

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
border on last cell of page effects border on beginning cell of ne	GaryE	Excel Discussion (Misc queries)	0	March 23rd 09 05:47 AM
border	Sarah	Excel Worksheet Functions	2	December 2nd 07 12:55 AM
Border	MADDY	Excel Discussion (Misc queries)	5	November 30th 07 04:55 AM
Changing the border of one cell s/n change the border of adjacent	gjanssenmn	Excel Discussion (Misc queries)	2	October 5th 05 08:35 PM
Border	Derrick Robinson	Excel Worksheet Functions	2	May 9th 05 03:00 AM

All times are GMT +1. The time now is 03:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us