excel range selection
 

Hi all,
I'm working in c# with Excel.Range objects.
I would like to know if the Exce.range object always refers to the active
sheet or if it can refer to a different sheet. I mean: may I work on a range
of cell belonging to a sheet different from the active one?

Thanks,

faffo1980

excel range selection
 

yes, you can set the range object to any sheet

"faffo1980" wrote:

Hi all,
I'm working in c# with Excel.Range objects.
I would like to know if the Exce.range object always refers to the active
sheet or if it can refer to a different sheet. I mean: may I work on a range
of cell belonging to a sheet different from the active one?

Thanks,

faffo1980

excel range selection
 

Refer the worksheet object. (VB code)

Dim ws as Excel.Worksheet
SEt ws = Worksheets("Sheet1")
Msgbox ws.Range("A1")

If this post helps click Yes
---------------
Jacob Skaria


"faffo1980" wrote:

Hi all,
I'm working in c# with Excel.Range objects.
I would like to know if the Exce.range object always refers to the active
sheet or if it can refer to a different sheet. I mean: may I work on a range
of cell belonging to a sheet different from the active one?

Thanks,

faffo1980