| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reset my format cell properties
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 Im not to sure how to do it. -- thank You gus chuchanis |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
reset my format cell properties
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
reset my format cell properties
Using Sheet1.Cells.ClearContents will preserve your formatting.
Regards Per "Gus Chuch" skrev i en meddelelse ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
reset my format cell properties
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I reset the default cell alignment format to Left-Top? | Excel Discussion (Misc queries) | |||
| How to reset incorrect date format after reinstalation of Window X | Setting up and Configuration of Excel | |||
| Format a Userform Textbox Properties | Excel Programming | |||
| reset charting default format within a workbook | Excel Worksheet Functions | |||
| Setting format properties when opening Worksheet | Excel Worksheet Functions | |||
Linear Mode
