Range of an Excel Sheet


A

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
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top