Save Method
 

Hi Bob, Thanks a lot! I am new and sorry for my ignorance.
How do you just save a few cells' borders and background
within a big Excel file and then restore those borders and
background? Do you have any sample code for that?
Chris

-----Original Message-----
You would need to loop through them all, save the
details, and restore
afterwards.

Why not just leave 'em be? Try ClearContents instaed of
Clear.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Chris" wrote in message
...
I am a beginner in Excel programming. There are a bunch
of
cells with colored borders and colored background. I
programmed a button to clear all of the colored borders
and background for certain purpose. My question is at
the
end of the program, I need to find some ways to restore
the original colored borders and background. How to
achieve and restore that?

Thanks all!

Chris