Range of an Excel Sheet

[Amrit]

I want to open a linked Excel Sheet with the appropriate range.

The excel filename / range I have is the following:

C:\Documents and
Settings\aparmar\Desktop\Book1.xslx!Sheet!R1C1:R5C2

I'm opening the following by stripping of the extra information :
C:\Documents and
Settings\aparmar\Desktop\Book1.xslx

How do I select the Range in Excel using !Sheet!R1C1:R5C2 ?

thanks,
Amrit

 

[Gord Dibben]

Command lines to open workbooks do not include specific sheets and ranges.

To open to a specific sheet and range selection you must use VBA

Name the range then add this code to Thisworkbook module of Book1.xlsx

Private Sub Workbook_Open()
Application.Goto Reference:="myrange"
End Sub


Gord Dibben MS Excel MVP