PDA

View Full Version : how to write code for doing format cells/ patterns/ no vcolors?



maryam
06-12-2007, 03:18 AM
I have a worksheet in which I gave colors to the cells. I want to clean the sheet when I start. How to write the code to do this instead of doing it manually via format cells/ patterns/ no colors?

Bob Phillips
06-12-2007, 04:10 AM
Cells.Clear