| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select last 3 rows of variable length coloumn in excel 2003?
I have text in a coloumn. The number of rows in the coloumn can vary. Can
somebody help me with either excel marco command(s) or VB script that can select last 3 rows of the coloumn from when the active cell is at the header row of the coloumn. One can assume the coloum always contains at least 3 rows. Thanks in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
select last 3 rows of variable length coloumn in excel 2003?
Hi Jay,
Try: Cells(Rows.Count, ActiveCell.Column).End(xlUp).Offset(-2).Resize(3).Select --- Regards, Norman "jay" wrote in message ... I have text in a coloumn. The number of rows in the coloumn can vary. Can somebody help me with either excel marco command(s) or VB script that can select last 3 rows of the coloumn from when the active cell is at the header row of the coloumn. One can assume the coloum always contains at least 3 rows. Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003: In a Macro,how to select a variable row length table | Excel Discussion (Misc queries) | |||
| Reading Rows of Variable Length | Excel Programming | |||
| Counting Variable Length of Rows in a Named Range | Excel Programming | |||
| Counting Variable Length of Rows in a Named Range | Excel Programming | |||
| Counting Variable Length of Rows in a Named Range | Excel Programming | |||
Linear Mode
