View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin Kevin is offline
external usenet poster
 
Posts: 21
Default Locate max value cell

There is probably a simple way to do this, but I can't
find it. I need to locate the cell with the highest
value in a range, to dymanically build another named
range, based on that loaction. I need a function to
return the cell address so I can parse it and use it as
the reference in the offset function within my dynamic
named range.

thanx

kpd