Copy a cell value as text over to column B
Posted on 2013-05-31
Looking for VBA that will on active sheet, check for red cell formatting in column AI and where ever it finds one, copy as text whatever is in that row over to column B and turn that one red as well, continuing down column AI until it does not find anymore. There are blank cells in AI then a few red the a few more blanks and then more reds...
We are using Interior.ColorIndex = 3 for red. -R-