General information
Category:
COM/DCOM and OLE Automation
>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?
Stop thinking in terms of "where you are" and instead, think of the cells in Excel like a two-dimensional array. You keep variables that track what you're doing, just as you would for an array.
Tamar
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only