View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ZAkar ZAkar is offline
external usenet poster
 
Posts: 3
Default Jumping back to a cell

Hello

within vb I read some values from my worksheet into a 2-dim table. The values of the cells and their references are kept in this table. After a sort, I want to change the property of the cells that keep the 5 highest values. So, next I want to jump back to these cells by their cell reference that is kept in the second column of my table. Unfortunately, after numerous attempts with e.g. ActiveCell etc... I did not get it to work

Does somebody have an idea

Highly appreciated
ZAkar.