Information générale
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement