Re: How to work with only one colum of a variant

From: Alan Beban <unavailable>
Date: Tue, 10 Apr 2007 09:37:29 -0700

Oh, that!:-)

Dave Peterson wrote:

But it's showing up as April 10th.

Alan Beban wrote:
I don't think so. I'm posting this at 4:54.

Dave Peterson wrote:
Alan,

Time to check the date/timezone on your pc.

Alan Beban wrote:
Where arr is the name of your variant variable

Application.Min(Application.Index(arr, 0, n))

will find the minimum in the nth "column".

Alan Beban

Gunnar Aronsen wrote:
I'm work a lot with variant data type, and I need a method to find the min
value in a column with use of a function. I know that worksheetfunction can
be used on a variant. Is there a function that allow me to adress only one
colum or row in a variant datatype.

Regards
Gunnar Aronsen
TrÃ¸nder Energi Kraft AS
Norway

References:
- Re: How to work with only one colum of a variant
  - From: Alan Beban
- Re: How to work with only one colum of a variant
  - From: Dave Peterson
- Re: How to work with only one colum of a variant
  - From: Alan Beban
- Re: How to work with only one colum of a variant
  - From: Dave Peterson

Prev by Date: RE: Automation error. The object invoked has disconnected
Next by Date: Re: Using the Dictionary object
Previous by thread: Re: How to work with only one colum of a variant
Next by thread: Copy paste to another Workbook, Error 1004
Index(es):
- Date
- Thread