| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear cells in a column that contain 0
Just use two quotes for each instead of one (the first quote is the
literal identifier) Range("E2").Formula = "=IF(VLOOKUP(A2,Items.csv!A:F,3,FALSE)="""","""",V LOOKUP(A2,Items.csv! A:F,3,FAL*SE)" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a Clear button to clear unprotected cells | Excel Programming | |||
| Clear cells in Column D if not = Auto | Excel Programming | |||
| How do I clear a column of data without clearing specific cells? | Excel Discussion (Misc queries) | |||
| clear column | Excel Programming | |||
| Clear cells range if certain cells are all empty | Excel Programming | |||
Linear Mode
