xlSheet.get_range not there

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to use the get_range method on an Excel sheet, but when I type
'xlSheet.' I don't see the method in the drop-down. I see Cells, Name, etc,
but I don't see any method starting with a "g". This is my code:

Dim workbook As Excel.Workbook =
workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet)
Dim xlSheet As Excel.Worksheet = CType(workbook.ActiveSheet, Excel.Worksheet)
xlSheet.get_Range(.......) 'I CAN'T DO THIS

I do have "get_range" available in my C# project, but not VB project.
According to documentation it should be available for VB as well. I don't
know what I'm doing wrong.

I would appreciate your help. Thank you!
 
I'm trying to use the get_range method on an Excel sheet, but when I type
'xlSheet.' I don't see the method in the drop-down. I see Cells, Name, etc,
but I don't see any method starting with a "g". This is my code:

Dim workbook As Excel.Workbook =
workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet)
Dim xlSheet As Excel.Worksheet = CType(workbook.ActiveSheet, Excel.Worksheet)
xlSheet.get_Range(.......) 'I CAN'T DO THIS

I do have "get_range" available in my C# project, but not VB project.
According to documentation it should be available for VB as well. I don't
know what I'm doing wrong.

I would appreciate your help. Thank you!
Click to expand...

Have you tried it even though it doesn't show up in intellisense?

Thanks,

Seth Rowe
 
Back
Top