Filling the blanks in ActiveCell.CurrentRegion?

[London_Calling]

Morning.

I'm pretty sure there's a straightforward way to select a range, perhaps like this:

myrange = ActiveCell.CurrentRegion

... and, from there, have something inserted in any empty cells within that range - fwiw, I use the word 'gap'. At the moment I loop through the range, but the fact there is almost certainly something better is nagging at me.

Any suggestions gratefully received!

 

[Richard Schollar]

As long as it is the same value in each blank cell (or formula) then:

myRange.SpecialCells(xlCellTypeBlanks).Value = "I am blank"

 

[London_Calling]

Thanks Richard, I swear I have a blank cell in my head when it comes to remembering SpecialCells. Cheers.