In Visual FoxPro using automation (VBA) code to move around in EXCEL, I know that I can move down one row by doing something like:
oRange = oRange.Offset(1,0)
Or I can find out the last Row where something was actually written to a row and column, as follows:
lnLastRow = oSheet.UsedRange.Rows.Count
But, what other ways are there? For example, how can you know where you stand with a ROW or COL OffSet?
What other ways can you find out where you are at any moment in an Excel file when loading data to it?