That cheating!, but very cool. I didnt know you could do that.
thanks

--
thank You


"Keith R" wrote:

Since this is dependent on specifically which cells you want to format, the
easiest place to start is probably to begin with your blank worksheet, then
record a macro and walk through all of the formatting you need. Then you can
start with that recorded macro code and adjust it as needed (including
throwing in the sheet name, etc.). If you get stuck troubleshooting that
code, then copy/paste the relevant sections here with questions about the
troublesome areas. :)

HTH,
Keith
"Gus Chuch" wrote in message
...
How can I reset my format cell properties back after I do a
Sheet1.Cells.Clear?
I have each cell with a border outline and some cells I merge together. I
think I have to use the range object but I'm not to sure how to do it.

--
thank You
gus chuchanis