LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Naming word tables or coding reference library with vba hornbecky83 Charts and Charting in Excel 6 January 21st 07 01:11 AM
Pivot Table Group Naming Arun Excel Discussion (Misc queries) 3 June 26th 06 10:58 PM
protection de-activating tab-naming code Stilla Excel Worksheet Functions 2 May 23rd 06 05:21 PM
Naming a Pivot Table??? ddawg09 Excel Discussion (Misc queries) 3 February 11th 06 08:44 PM
Naming Pivot Table Paramater Report Shrikant Excel Discussion (Misc queries) 3 August 25th 05 10:15 PM


All times are GMT +1. The time now is 04:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"