Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

A macro to change the color of the border of a cell

Posted by Kurt on August 14, 2000 4:18 PM

Hello everyone!

Is there a way to write a macro to change the color of the border of a cell?

Thanks again in advance.

Kurt

Re: A macro to change the color of the border of a cell

Posted by Celia on August 14, 0100 4:26 PM

Kurt
Yes, just use the macro recorder to obtain the code.
Celia

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.