View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gunnar Aronsen Gunnar Aronsen is offline
external usenet poster
 
Posts: 3
Default How to work with only one colum of a variant

I have a variant which has several columns. I want to find the min and
maxvalue in one of these colum.

What I want to do is analoge to use this function:

MinValue=worksheetfunction.Min(MyRange.columns(2))

I also found out that this function is working on a variant datatype, but
only on the whole array.

Regard
Gunnar