Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Best method to populate cell based upon drop down list selection | Excel Discussion (Misc queries) | |||
Excel 2007 - referencing a cell value from another worksheet withi | Excel Discussion (Misc queries) | |||
Random selection method | Excel Discussion (Misc queries) | |||
Random Selection of Some Lines in Excel Worksheet | Excel Worksheet Functions | |||
Activate method of Worksheet class fails in Excel 2000 | Excel Discussion (Misc queries) |