View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cat Cat is offline
external usenet poster
 
Posts: 63
Default 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