reset my format cell properties

[Gus Chuch]

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.

 

[Keith R]

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

 

[Per Jessen]

Using Sheet1.Cells.ClearContents will preserve your formatting.

Regards

Per

 

[Gus Chuch]

That cheating!, but very cool. I didn’t know you could do that.
thanks

--
thank You

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