View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Tim Rush Tim Rush is offline
external usenet poster
 
Posts: 27
Default Max/Min for variable length columns

Got it, Thanks...

"Gordon Rainsford" wrote:

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