xllastcell vs xlcelltypelastcell

[Paul Lautman]

Occationally when I record a macro, Excel inserts .specialcells(xllastcell).

However, I cannot find this value documented anywhere. The nearest that the
MS documentation gets is xlcelltypelastcell.

Is there a difference between these two?

If so, where do I find xllastcell documented?

TIA

 

[Jim Rech]

Both constants evaluate to 11. In Excel 97 MS gave new names to many of
Excel's defined constants but they had to continue to support the older
names for compatibility reasons.

--
Jim Rech
Excel MVP
| Occationally when I record a macro, Excel inserts
..specialcells(xllastcell).
|
| However, I cannot find this value documented anywhere. The nearest that
the
| MS documentation gets is xlcelltypelastcell.
|
| Is there a difference between these two?
|
| If so, where do I find xllastcell documented?
|
| TIA
|
|

 

[Paul Lautman]

Thanks Jim, so which are the newer names?

The documentation only lists xlcelltypelastcell, but the macro recorder
inserts xllastcell?

 

[Tom Ogilvy]

the one listed is the newer name.