If one has a Range named in an Excel file - ie MyRangeName, using OfficeInside, how does one return the row number for that range? My search of the Office Inside docs has come close but is empty.
I’ve no idea how OfficeInside might do it, but ROW(MyRangeName) and COLUMN(MyRangeName) will give you the top left of a range as a formula in an excel cell
I’ve concluded there is not a way in the current OfficeInside release to do this. These basic functions in Excel do of course exist. If I can find some time, I hope to extend OfficeInside and call the Excel functions.