Re: End(xlUp) vs SpecialCells(xlCellTypeLastCell)
As I understand, the SpecialCells method finds the last cell - this may not actually be what you are looking for. The End method finds the last used cell in a particular Column or Row
Re: End(xlUp) vs SpecialCells(xlCellTypeLastCell)
Remember xlCellTypeLastCell might not be in Your data set(s) so it could mislead You
end(xlUp & xlDown) have proved to report far better, depends what You want i guess?
jiuk
Re: End(xlUp) vs SpecialCells(xlCellTypeLastCell)
Problems with the SpecialCells approach are, I think, pretty rare. You may find something on JWalk's site about this - I'd post a link if I could remember the exact place!
That said, once you read about an approach that may cause problems you tend to use an alternative 
(I use the End(xlUp) approach in my code).
EDIT : Mention of the problem is made here but in no great detail.
Don’t have an account yet? Register yourself now and be a part of our community!