Yes, "it returned a range consisting of multiple cells for a single call"

I believe I was looking for the last column and LastCell was returning a reference to two
or three cells from the same row.
This was in August 2010 - I did not keep detailed notes, just a message to myself about
don't do that.
I suspect it is a rare occurrence and something could have contributed to it, but I don't
know what.
The UsedRange seems to be a reliable method for finding a general starting area.
'---
Jim Cone




"Rick Rothstein"
wrote in message
...
In addition, I have had SpecialCells(xlCellTypeLastCell) return multiple cells.

Do you mean it returned a range consisting of multiple cells for a single call to
SpecialCells? Or did you mean it returned one cell the first time you called it and a
different cell the next time it was called?

Rick Rothstein (MVP - Excel)