Thread: Selection method not available in VB when referencing Excel worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Oscar Oscar is offline
external usenet poster
  
Posts: 35
Default Selection method not available in VB when referencing Excel worksheet
In a VB application, I am referencing an Excel workbook. I need to know the
row number of the toprow and bottomrow of any range selection. Therefore I
want to use the selection object. However, the 'selection' object is not
available for the Excel.worksheet method and is only available for the
Excel.application and it doesn't show any method after selection. For
example I can't use selection.rows. How can I change this ?

Oscar


Reply With QuoteReply With Quote