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.