Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
EXCEL Automation in VFP
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01513555
Message ID:
01513566
Views:
69
>If you want to jump and write your data from a RANGE of ("A3:F3") to ("H3:M3") how would you do this numerically? When you finish your first month in the first range, you then start the 2nd month in the next range of H3:M3, then the 3rd month further to the right likewise.
>
>I have 12 months of data I must show across the spreadsheet from left to right. Since the columns are using alpha characters, is there a way with automation to make the jump using numbers?
>
>Cecil

You can address the cells by row and column
ExcelObject.ActiveWorkBook.Sheets[1].Cells(rownumber, columnnymber).Value = 123
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform