I am trying to understand the difference between Worksheet.Range() and Worksheet.get_Range(). Take the two lines of codes below:
Globals.ThisWorkbook.Worksheets["Sheet1"].Range("A4").Value2 = "test";
This will print "test" on cell A4 on worksheet labelled "Sheet1". Similarly,
Globals.ThisWorkbook.Worksheets["Sheet1"].get_Range("A4").Value2 = "test";
should produce the same result, instead I got:
'System.__ComObject' does not contain a definition for 'get_Range
Can someone explain when and how to use get_Range()?
Is there any performance benefit?