I have done some very large programs in VB, but I have always had
trouble with Excel objects.

I want to clear rows on a spreadsheet - from a named range row and the
last used row on the spreadsheet.

My attempt is like this:

OutRow = .Range("MonteCarloPaste").Row
Range(.Cells(OutRow, 1), .Cells(OutRow, 1).SpecialCells
(xlCellTypeLastCell)).ClearContents

(It is inside a With statement referring to the sheet in question.)

Even the following doesn't work:

Range(.Range("A6"), .Range("A6").SpecialCells
(xlCellTypeLastCell)).ClearContents

Annoyingly, the following does work fine:

..Cells(OutRow, 1).SpecialCells(xlCellTypeLastCell).Value

What I am doing wrong?

Thanks for any help in advance!