View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GreenInIowa GreenInIowa is offline
external usenet poster
 
Posts: 38
Default Row Number of Max Value

Hi,

I have an array and would like to get the "column" number of the maximum
value in that array. I can get the address of max value by "maxval =
n.Address(maxvalue)" as $E$1, but I would like to get column the number as
numerical value. I tried "colnum = n.Column(maxvalue)" and it is not working.

Any suggestions how I can get column number?

Thanks.