Posted to microsoft.public.excel.programming

extrapulp

external usenet poster

Posts: 1

Cells.Interior.Color question

I have successfully used the Cells.Interior.Color = X but in certain cases I
want to undo the change. I have tried Cells.Interior.Color = vbWhite but then
the cell border is gone.

Is there a way to set the color back to white (or automatic) and have the
cell borders show back up?

Thanks

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
Sort by Cells Interior Color Then by Date	RyanH	Excel Programming	3	January 19th 10 05:38 PM
lock cells based on interior color	MIke	Excel Discussion (Misc queries)	4	December 27th 07 08:59 PM
Quick question Finding a cell by interior color	Celt[_43_]	Excel Programming	3	April 5th 06 06:40 PM
cells interior/color index	tandavina[_7_]	Excel Programming	4	February 12th 06 11:28 AM
Sum all cells with interior color...	Ctech[_65_]	Excel Programming	4	January 11th 06 07:46 PM

All times are GMT +1. The time now is 05:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us