General information
Title:
Integrating Memory Variables Into VBA Statements
In Excel 97-sr2 I am determining the last used row of spreadsheet using
the following code:
Range("A1").Select
LastRow = ActiveSheet.UsedRange.Rows.Count
It is my intent to then import additional data two rows below the
LastRow.
What would be the correct way of referencing the variable LastRow?
I suspect the code Range("A1").Select Would need to become
Range("A"+m.LastRow).Select.
(well, it would look something like that in Foxpro..)
That I tried, but of course it did not work.
Thanks!
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