Clear Contents - Specific Cells

[meledward23]

So I after a copy and paste, I am trying to clear contents of specific cells.

.Cells(LRow + 1, 9).EntireRow.SpecialCells(xlCellTypeConstants).clearcontents

this clears the proper row. But everything.

.Cells(LRow + 1, 9).SpecialCells(xlCellTypeConstants).clearcontents

This clears my entire sheet.
So clearly I am not understanding something properly.

(Lrow 2nd to last row of a range, so I can insert before the end, so I am getting the right row when I do entire row)

 

[Fluff]

If you use specialcells on a single cell (as in your 2nd example), it looks at the entire sheet.
Just use the code in your 1st example