excel range selection

  • Thread starter Thread starter faffo1980
  • Start date Start date
F

faffo1980

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
 
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
 
Back
Top