Excel/VBA Questions

[Chris]

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

 

[Bob Phillips]

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]

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