Vba for determing UsedRange when blank (used earlier) cells is present

[kit99]

I've been using this one:

    For Each c In ActiveSheet.UsedRange
    If c.Value = "" Then c.Value = "n/a"
    Next

... for adding "n/a" to blank cells in UsedRange.

But now I'm getting into trouble 'cause of earlier use of this ws/sheet. When running code, the code applies "n/a" to cells in rows below UsedRange. This is rows that had data in them the last time I used this sheet/code.
So I tried to put his line above my code:

    Worksheet.UsedRangeIncludesFormatting = False

But it ends in error: Run-time error '424': Object required.
Any ideas on how to fix this?

 

[Fluff]

One option would be

Dim x
Set x = ActiveSheet.UsedRange
For Each C In ActiveSheet.UsedRange
   If C.Value = "" Then C.Value = "n/a"
Next

or maybe just

Range("A1").CurrentRegion.SpecialCells(xlBlanks).Value = "n/a"

 

[kit99]

One option would be

Dim x
Set x = ActiveSheet.UsedRange
For Each C In ActiveSheet.UsedRange
   If C.Value = "" Then C.Value = "n/a"
Next

or maybe just

Range("A1").CurrentRegion.SpecialCells(xlBlanks).Value = "n/a"

Your first suggestion doesn't do any good. It still adds "n/a" to cells in previous used rows below my new range.
But your second suggestion works great.

Thanks a lot for helping out!

 

[Fluff]

Glad to help & thanks for the feedback