LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default referencing to matrix labels

I would like to know if the following is possible...

I have several labeled several cell matrixes.
I can reference to these matrixes in formulas in other cells... no
problem there.

But I would like to do the following: I have written the name of the
label in a cell. I would like to get the name of this label from this
cell so I can make reference to it in a formula.

Little example:

cell range A1:A2 has the label "TestLabel"

A3 has the value "TestLabel"

A4 I want to have the formula: =sum(A3)
(this should take the sum of the range defined in A3 (A1:A2), but
obviously doesn't work...


Excel needs to understand that the value of the the cell A3 is a
label. Can anyone tell me how I should do this?


Thanks in advance,

Regards,
Thijs van Bon

 
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
Printing labels on a dot matrix via Excel sdrais Excel Discussion (Misc queries) 1 July 20th 06 10:49 PM
Printing labels on a dot matrix printer - what does this code do Laurence Lombard Excel Discussion (Misc queries) 2 June 19th 06 06:15 AM
Printing labels on a dot matrix printer - what does this code do Laurence Lombard Excel Discussion (Misc queries) 0 June 16th 06 07:18 AM
Return a value by referencing row and column labels? Cellzman Excel Discussion (Misc queries) 6 December 2nd 05 04:08 PM
Referencing labels dynamically. liddlem[_3_] Excel Programming 2 January 16th 04 05:24 PM


All times are GMT +1. The time now is 06:44 PM.

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"