| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear cell
I am setting cell formats using the With Selection.Interior
.ColorIndex = 0 .Pattern = xlGray8 .PatternColorIndex = xlAutomatic ? Can I clear the cell value by adding another expression to this? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
clear cell
John,
Selection.ClearContent -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 97 ** remove news from my email address to reply by email ** "John Keturi" wrote in message news:3IoEc.4181$151.3051@fed1read02... I am setting cell formats using the With Selection.Interior .ColorIndex = 0 .Pattern = xlGray8 .PatternColorIndex = xlAutomatic ? Can I clear the cell value by adding another expression to this? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
clear cell
One way:
With Selection.Interior .ColorIndex = 0 .Pattern = xlGray8 .PatternColorIndex = xlAutomatic .Parent.ClearContents End With In article <3IoEc.4181$151.3051@fed1read02, "John Keturi" wrote: I am setting cell formats using the With Selection.Interior .ColorIndex = 0 .Pattern = xlGray8 .PatternColorIndex = xlAutomatic ? Can I clear the cell value by adding another expression to this? Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
clear cell
Note: Should be
Selection.ClearContents In article , "Paul B" wrote: Selection.ClearContent |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I clear a cell | Excel Discussion (Misc queries) | |||
| Transfer a name from one cell to another but leave clear if clear? | Excel Worksheet Functions | |||
| clear the clear the web page email attachment lines | Excel Discussion (Misc queries) | |||
| Clear cell when value is 0 | New Users to Excel | |||
| Type into one cell and automatically clear contents in another cell | Excel Programming | |||
Linear Mode
