Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Integrating Memory Variables Into VBA Statements
Message
 
To
All
General information
Forum:
Visual Basic
Category:
VBA
Title:
Integrating Memory Variables Into VBA Statements
Miscellaneous
Thread ID:
00271741
Message ID:
00271741
Views:
71
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
Map
View

Click here to load this message in the networking platform