Naming a reference table for use in a VBA Code
Thank you very much Per, that will save a few blushes if and when I receive
replies to my new query in "Program"
Kind Regards
Cat
"Per Jessen" wrote:
Hi Cat
To name a range, select the range and goto Insert Name Define Enter
"ColorTable" OK
The sheet tabs are found at the bottom of the window, normally named Sheet1
, Sheet2 and Sheet3 (used to select a sheet).
Regards,
Per
"CAT" skrev i meddelelsen
...
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
|