Thread: Selecting a cell from an index
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Canuck[_2_] Canuck[_2_] is offline
external usenet poster
  
Posts: 1
Default Selecting a cell from an index
Hello,
I'm looking to set a cell as the 'activecell' from an index of cells.
What I need is when activating a command button it sets as the activ
cell in a range of cells the one with the highest value.

For example: A1 = 1, A2 = 3, A3 = 10, A4 = 6
utilizing the command button sets A3 as th
activecell

any help would be appreciate

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote