| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concise Way To Select All Rows Except First?
I guess I want to concoct a .Range and then operate on it.
But, short of iterating thorugh rows to find the last row, I can't figure out how to do it. Googled a little, and "ActiveCell.SpecialCells(xlLastCell) seems to have the right ring to it. True? Either way, can somebody shed some light? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can i randomly select 780 rows from 4000 rows of data | Excel Worksheet Functions | |||
| Concise Way To Tell If Range Contains Any Data? | Excel Programming | |||
| More Concise Way To Assign Borders? | Excel Programming | |||
| Make instructions clear, concise and in plain english. | Excel Discussion (Misc queries) | |||
| Concise border removal method | Excel Programming | |||
![PeteCresswell[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
