AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 2,099
- Office Version
- 2019
- 2010
- Platform
- Windows
I'm moving some data from one computer to another which has an updated workbook.
I want to duplicate the backcolors in e,g, O62:CL108 without needing to do it manually.
My thinking it to write a file the other one can read and assign the backcolor values.
But I haven't yet figured out the best to read a range of backcolors and reapply them.
Any suggestions most welcome. Does the range object contain the backcolors?
I want to duplicate the backcolors in e,g, O62:CL108 without needing to do it manually.
My thinking it to write a file the other one can read and assign the backcolor values.
But I haven't yet figured out the best to read a range of backcolors and reapply them.
Any suggestions most welcome. Does the range object contain the backcolors?