Background color in cells
I have Blank spreadsheet with Row 1 starting at B1...AY filled with
numbers 1 to 49.
Rows 2 to 30 Blank with columns 49 ending at row AY30
A separate list of 6 numbers X42 to AC44 contains the following
1 6 16 32 41 45
24 35 36 38 47 48
13 15 18 32 34 35
I world like to have VBA code using the list X42..AC44
to background fill with Color, the Blank rows and columns.
Any direction would be appreciated
|