View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robin Clay[_2_] Robin Clay[_2_] is offline
external usenet poster
 
Posts: 14
Default Maximum of selection

Greetings !

Having selected a block say 4 columns wide and 12 rows
long, I want to establish the maximum value of the
selected cells in a particular column.

I have tried
myMax = MAX( _
Selection.FirstCol & _
Selection.FirstRow & ":" & _
Selection.FirstCol & _
Selection.LastRow)
but it doesn't work.

I would be most grateful if SKS would please furnish me
with the right expression.

And also, how would that expression change to find the
maximum of say the third column ?