0 or 1 Based


Everything is zero based.
worksheet.getCell(0,0) is the first cell in JavaScript
worksheet.cells(1,1) is the first cell in VBA and C#.


Worksheet function arguments however will be 1-based for consistency purposes.
vlookup("blue",A1:D10",2) will return the value from the second column


Likewise the result from the Match function will be 1 based.





© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext