Replacing blank cells with text

[Marisoleil]

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

 

[johnwm]

Welcome to Tek-Tips. Please read faq222-2244 which will guide you to repost this question in forum707

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints