Perform multiplications on grey shaded cells using VBA
Posted on 2013-12-11
I would like to perform the following action using VBA on the current workbook
... Look for grey shaded cells (RGB 222, 222, 222) in all worksheets of the current workbook with exception of one named 'MasterSheet'
... If found perform the following multiplication:
C5 (Cell reference in worksheet 'MasterSheet') times the value found in that grey shaded cell
... Do the loop with this multiplication.
Help is much appreciated. Thank you very much in advance.