ExcelBanter - Clear cells in a column that contain 0

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Clear cells in a column that contain 0 (https://www.excelbanter.com/excel-programming/431625-re-clear-cells-column-contain-0-a.html)

jasontferrell

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)"

All times are GMT +1. The time now is 10:49 AM.