xllastcell vs xlcelltypelastcell

P

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
 
J

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
|
|
 
P

Paul Lautman

Thanks Jim, so which are the newer names?

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