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?