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

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
"Paul Lautman" wrote in message
...
| 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
|
|

Thanks Jim, so which are the newer names?

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

"Jim Rech" wrote in message
...
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
"Paul Lautman" wrote in message
...
| 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
|
|

the one listed is the newer name.

--
Regards,
tom Ogilvy

"Paul Lautman" wrote in message
...
Thanks Jim, so which are the newer names?

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

"Jim Rech" wrote in message
...
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
"Paul Lautman" wrote in message
...
| 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
|
|