M
Maxx
Sheet 1 contains a (2 digit) integer in each of cols A to F.
There are no duplicates. There are no integers greater than 50.
I would like to shade the background of the cell in sheet 2 where the
integers in sheet 1 are the column numbers.
So, for example, if Sheet1.Range("A1") = 27 then
Sheet 2.Range("A27").interior.color = black.
The row numbers would be the same on both sheets.
I hope this makes sense.
There are no duplicates. There are no integers greater than 50.
I would like to shade the background of the cell in sheet 2 where the
integers in sheet 1 are the column numbers.
So, for example, if Sheet1.Range("A1") = 27 then
Sheet 2.Range("A27").interior.color = black.
The row numbers would be the same on both sheets.
I hope this makes sense.