Naming a reference table for use in a VBA Code
Hello everyone,
I am fairly new to Excell and have no knowledge of VBA programming. I use
Excell 2007.
In reply to a query I made in "Programming", I was asked to do the following:
Name my two columns in the lookup table (AM1:AN29) ColorTable, then copy the
code below, right-click the sheet tab, select "view Code" and paste Code into
the window that appears.
*Where (in which cell) do I insert the word "ColorTable"?
*Where is the sheet tab situated? so that I then right-click and get to
"View Code", in order to paste the Code in said window that will open?
I would be grateful for an answer to those questions as I haven't a clue of
how to proceed.
It also means I can move on with my original query in the Program Section
which is fast disappearing and maybe reword it in simpler terms.
Thank you very much for your help
Cat
|