View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gordon Rainsford[_3_] Gordon Rainsford[_3_] is offline
external usenet poster
 
Posts: 26
Default Max/Min for variable length columns

Gordon Rainsford wrote:

Cells(i + 1, 4).Value = minValue
Cells(i + 1, 3).Value = "Minimum Value"


These final two lines should read:

Cells(i + 1, Selection.Column).Value = minValue
Cells(i + 1, Selection.Column - 1).Value = "Minimum Value"


--
Gordon Rainsford

London UK