| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Easy Question about selecting Ranges
Many thanks
"Tom Ogilvy" wrote in message ... You can only select on the activesheet. An alternative approach Sheets("Worksheet 1").Select Range("A8").Select if the workbook is not active Workbooks("MyBook.xls").Select Sheets("Worksheet 1").Select Range("A8").Select if you execute the code from within a class module such as a sheet module or the thisworkbook module Workbooks("MyBook.xls").Select Workbooks("MyBook.xls").Sheets("Worksheet 1").Select Workbooks("MyBook.xls").Sheets("Worksheet 1").Range("A8").Select as any unqualified references will be qualified with the sheet or workbook associated with that module. -- Regards, Tom Ogilvy "Andibevan" wrote in message ... Hi All, This is a really basic question that I can't work out. Why can't I use sheets("Worksheet 1").Range("A8").Select to select a range on another worksheet? And am I correct in thinking the only way to do it is:- Application.Goto Activeworkbook.Sheets("Worksheet 1").Range("A8") Thanks in advance Andi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting mutliple ranges | Excel Worksheet Functions | |||
| new user with easy question? not easy for me | New Users to Excel | |||
| Selecting ranges | Excel Programming | |||
| an easy question (to some of you, but not to me) on named ranges | Excel Programming | |||
| selecting ranges | Excel Programming | |||
![Andibevan[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
