Thread: Refedit
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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