Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displayed Collumns and Rows
I would like to find the actual rows displayed in the
activesheet. Any code examples would be greatly appreciated. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displayed Collumns and Rows
John,
Try these: ActiveWindow.VisibleRange.Rows.Count ActiveWindow.VisibleRange.Columns.Count John John Tripp wrote: I would like to find the actual rows displayed in the activesheet. Any code examples would be greatly appreciated. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displayed Collumns and Rows
Not sure if I understand you?
Excel 97 and up have 65536 rows ' rows in sheet MsgBox Rows.Count ' this count the rows in the usedrange(a1:till the last cell) ' is not always correct MsgBox ActiveSheet.UsedRange.Rows.Count Or the CurrentRegion MsgBox Range("A1").CurrentRegion.Rows.Count Or do you mean visible rows?? MsgBox Columns("A:A").SpecialCells(xlCellTypeVisible).Cel ls.Count -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "John Tripp" wrote in message ... I would like to find the actual rows displayed in the activesheet. Any code examples would be greatly appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rows not being displayed | Excel Discussion (Misc queries) | |||
How do I sort collumns and leave out pictures in rows not used? | Excel Worksheet Functions | |||
How do I invert an Excel table (collumns become rows)? | Excel Worksheet Functions | |||
Switching from collumns to rows | Excel Discussion (Misc queries) | |||
Collumns and rows | Excel Discussion (Misc queries) |