I have a workbook with 93 'key' worksheets. The background for each of the tabs is one of nine colours. I am now trying to make the contents of a sequence of cells on another worksheet, within the same workbook, the name of one of the worksheets, in succession, and colour the cell with the same background colour as the tab from which the cell's value has been drawn.
I successfully used the following function to make the cell values the required value in each cell, obviously the function is called from each cell.
Setting a Cell's Value
Function Other_Worksheet_Name_GSU(WS_Number As Long)