VBA Color Operations

[rlderi01]

All,

I have manually-formatted cells colored colorindex =6, spread randomly throughout the sheet. I need to write a macro to select these colored cells, and use the offset function to move them (2, -1). Any help greatly appreciated!

RD

 

[rlderi01]

Thank you all so much! Fantastic help

 

[sous2817]

HURRAY! Glad it all worked out. Feel free to post again should you need any additional help.