View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Wilson John Wilson is offline
external usenet poster
 
Posts: 550
Default 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