Copy Cells Fill Color
How does column A gets its colors?
Gord Dibben MS Excel MVP
On Wed, 4 Feb 2009 12:08:16 -0800, FrankM
wrote:
Anyone?
"FrankM" wrote:
I have a spreadsheet extract that changes from month to month. Sometimes it
is 750 lines, sometimes 800 lines or 900 and sometimes 600.
Column A is sometimes a different color than columns B to I (these are the
only columns I'm concerned with).
I would like columns B to I to be the same color as column A.
I run a simple Macro to format print settings and column widths and so
forth. I'm hoping there is an easy code I can throw into the Macro to do the
Cell color too.
Any suggestions?
Thanks in advance!
|