John Baird
Coatesville, Pennsylvania, United States
General information
Category:
COM/DCOM and OLE Automation
Hi guys:
Working with excel automation from vfp. How do I determine the active range of cells which contain data, i.e. the rightmost column intersected with the bottomost row that contain data?
.rows.count returns 65,536 and columns.count returns 256.
I thought about using loops and testing for empty, but there may be empty cells which would not return the proper column or row.
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