Posted to microsoft.public.excel.programming

Stuart[_5_] Stuart[_5_] is offline

external usenet poster

Posts: 413

A Borders question

Why might the following not be removing the Right border,
please?

If C.Value = SEARCHFOR Then
C.Offset(-1, -2) _
.Borders(xlEdgeRight).LineStyle = xlNone

Regards.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.522 / Virus Database: 320 - Release Date: 29/09/2003

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
Micro to do borders question.	Damian	Excel Discussion (Misc queries)	3	August 31st 09 05:32 PM
borders	kim	Excel Discussion (Misc queries)	1	October 12th 07 10:24 PM
Question about borders	Paul Allor	Excel Discussion (Misc queries)	3	September 14th 07 03:16 PM
borders	Brush Prairie	Excel Discussion (Misc queries)	0	August 23rd 05 02:57 AM
Question about Cell Borders	Kevin	New Users to Excel	2	April 13th 05 01:36 AM

All times are GMT +1. The time now is 12:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us