(Excel app)How can I obtain the number of rows and columns of a range?

[Dhemaius]

Excel app:
I need to get the number of rows and columns of a range but I can't find out a way to do so.

[DanielMcchane]

Are you attempting this with our CVI SQL package, or with ActiveX control? I am going to guess SQL, which I don't see any way of getting the number of rows and columns for a designated range. Post back if you have a different scenario.

[IEE_newsoft]

Hi,

if you're using ExcelXP, here's the solution (for Excel2000 it would be similiar)