Dear All....
I know that this is possible as have seen it before, but using a defined table as ColourKey i want to create a macro that looks at the spreadsheet in given cell area, and then colours cells according to their names from the colourkey, any help would be appreciated... this is how far i've got prob wrong.
Sub ColourKey()
' Auto Colours Cells Using for Rota System and Holiday Maps
Dim ColourKey as
End Sub
Yeah i know not far eh!! lol
Kind Regards,
David
I know that this is possible as have seen it before, but using a defined table as ColourKey i want to create a macro that looks at the spreadsheet in given cell area, and then colours cells according to their names from the colourkey, any help would be appreciated... this is how far i've got prob wrong.
Sub ColourKey()
' Auto Colours Cells Using for Rota System and Holiday Maps
Dim ColourKey as
End Sub
Yeah i know not far eh!! lol
Kind Regards,
David