I would like to achieve the following using VBA
I got numerous grad shaded cells (RGB 222, 222, 222) in Column A of the active worksheet.
All of these grey shaded cells in Column A should be shifted to the right to Column B.
The non-grey cells should be left untouched.
I have attached a sample file for your convenience.
help is much appreciated. Thank you very much in advance.