how to read the data from -- >> Excel sheet

[Manmohan Singh]

hi All

how to read the data from Excel sheet.i have Range name, Sheet name.
how i can pickup data according to the range name........

Thanks
Manmohan Chauhan

 

[JE McGimpsey]

One way:

Assume Sheet name = "Sheet1", Range name = "MyRange":

=Sheet1!MyRange