Would like to know if there is a way to economize this code by use of an array. Essentially there are 11 target cells that trigger a color change of an object based on the value of the cell. Note that the target cells are in two ranges KA6:KA13 and KL6:KL8. The objects are consecutive names “SavLit” 1 to 11
Trying to sort out various pieces of code in a little project I have been building over the last several months. I have been trying to learn at the same time so now I need to learn how to make my code a bit leaner.
Thanks as Always
Scott
Bookmarks