View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
FrankM FrankM is offline
external usenet poster
 
Posts: 45
Default Copy Cells Fill Color

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!