Marisoleil
MIS
Hello,
I would like to replace blank cells with the value "999" for all rows but only within a specific range of columns.
Is it possible to do so using the following code:
Sheets("Sheet1").Columns("H:K").SpecialCells(xlCellTypeBlanks).??????
...and filling in something else for the question marks?
Thank you,
Marie
I would like to replace blank cells with the value "999" for all rows but only within a specific range of columns.
Is it possible to do so using the following code:
Sheets("Sheet1").Columns("H:K").SpecialCells(xlCellTypeBlanks).??????
...and filling in something else for the question marks?
Thank you,
Marie