Passing the cell reference to a variable
Hello,
within vba I read some values from my worksheet. The values and their references are kept in the table. After a sort, I want to do something with the cells of the, let's say, 5 highest values(e.g. changing color etc...).
But, after a sort, I want to go back to the cells keeping the 5 highest values and change their property.
Does somebody have an idea ?
Highly appreciated,
Artist.
|
