Last Cell Code
 

What's the difference in this

Selection.SpecialCells(xlCellTypeLastCell).Select

and this

ActiveCell.SpecialCells(xlLastCell).Select

Last Cell Code
 

There is no difference.

the top level qualifier (selection or activecell) has no effect on the
result.

You can also use

Range("A1").SpecialCells(xlCellTypeLastCell).Selec t

Cells.SpecialCells(xlCellTypeLastCell).Select

either of which would give identical results to the two you presented.

--
Regards,
Tom Ogilvy


"Terri" wrote in message
...
What's the difference in this

Selection.SpecialCells(xlCellTypeLastCell).Select

and this

ActiveCell.SpecialCells(xlLastCell).Select

Last Cell Code
 

So the words CellType doesn't need to be in the line of
code to have the same result?
(xlCellTypeLastCell)
or
(xlLastCell)



-----Original Message-----
There is no difference.

the top level qualifier (selection or activecell) has
no effect on the
result.

You can also use

Range("A1").SpecialCells(xlCellTypeLastCell).Sele ct

Cells.SpecialCells(xlCellTypeLastCell).Select

either of which would give identical results to the two
you presented.

--
Regards,
Tom Ogilvy


"Terri" wrote in
message
...
What's the difference in this

Selection.SpecialCells(xlCellTypeLastCell).Select

and this

ActiveCell.SpecialCells(xlLastCell).Select




.

Last Cell Code
 

Guess I misunderstood what the exact question was.


No, that doesn't make any difference either.

They both resolve to the same constant value:

? xlCellTypeLastCell
11
? xlLastCell
11


--
Regards,
Tom Ogilvy



wrote in message
...
So the words CellType doesn't need to be in the line of
code to have the same result?
(xlCellTypeLastCell)
or
(xlLastCell)



-----Original Message-----
There is no difference.

the top level qualifier (selection or activecell) has
no effect on the
result.

You can also use

Range("A1").SpecialCells(xlCellTypeLastCell).Sele ct

Cells.SpecialCells(xlCellTypeLastCell).Select

either of which would give identical results to the two
you presented.

--
Regards,
Tom Ogilvy


"Terri" wrote in
message
...
What's the difference in this

Selection.SpecialCells(xlCellTypeLastCell).Select

and this

ActiveCell.SpecialCells(xlLastCell).Select




.