title: Replacing blank cells with text in a specific range
body: <p>I have been attempting to patch together VBA fragments to create a macro to do the following:</p>
  
  <p>I must replace all blank cells within the active range with the word 'UNREPORTED'.  The range covers Columns C through L. Row 1 is the Column Headers, so it needs to effect Row 2 through the last active row.  The spreadsheet covers columns A to U, so I do not want to define all the way to the left or the right.  Column C will have no blank cells, so it may be useful for defining the active rows.  All other Columns could have a blank row at the bottom.</p>