Remove fill on printing - Cell Specific

[BrianOfNazareth]

Good evening,

I found this post http://www.excelforum.com/excel-prog...move-fill.html regarding the removal of cell shading when printing and was wondering if the solution could be made so that I could have the remove fill on a number of specific cells within the worksheet rather than the whole document?

This was the code that was suggested in the previous post

Private Sub Workbook_BeforePrint(Cancel As Boolean)
   Cells.Interior.ColorIndex = xlNone
End Sub

Any help you could offer would be greatly appreciated.

[StephenR]

Like this for example?

Private Sub Workbook_BeforePrint(Cancel As Boolean)
   Range("A1:A10").Interior.ColorIndex = xlNone
End Sub

[BrianOfNazareth]

Exactly that. Thankyou kindly for your time