| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Cell Code
What's the difference in this
Selection.SpecialCells(xlCellTypeLastCell).Select and this ActiveCell.SpecialCells(xlLastCell).Select |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
| Cell Translation Code | Excel Programming | |||
| Cell Formula to run VBA code | Excel Programming | |||
![Terri[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
