ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Refedit (https://www.excelbanter.com/excel-programming/413077-refedit.html)

Marvin Buzz

Refedit
 
I am using a refedit control in a form. How do I determine the number of
rows and columns in the range returned?

Thanks.

Dave Peterson

Refedit
 
If it's a single area, you can use:

range(refedit1.value).rows.count
range(refedit1.value).columns.count



Marvin Buzz wrote:

I am using a refedit control in a form. How do I determine the number of
rows and columns in the range returned?

Thanks.


--

Dave Peterson


All times are GMT +1. The time now is 01:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com