| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Label on one sheet gets captiuon from another
I have a worksheet ("PickSheet") with many labels on it. another sheet
("Data") contains a list of values that will change based on formulae. i must be going about this wrong, but i am trying to write a statement that will make a label's caption the value of the first cell in the range on ("Data") the first cell/range is named "Seed1". TIA. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Label on one sheet gets captiuon from another
Label1.Caption = Range("Seed1").Range("A1").Value
The top left cell of any NamedRange is refered to as "A1", etc. as if the range was a separate tiny spreadsheet. Wherever the NamedRange is placed within the workbook Range("NamedRange").Range("A1") will be the first cell of that range. Hope this helps Mike F "Spencer Hutton" wrote in message m... I have a worksheet ("PickSheet") with many labels on it. another sheet ("Data") contains a list of values that will change based on formulae. i must be going about this wrong, but i am trying to write a statement that will make a label's caption the value of the first cell in the range on ("Data") the first cell/range is named "Seed1". TIA. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the font for part of an axis label, not the whole label. | Charts and Charting in Excel | |||
| How do I get a cell to read sheet label? | New Users to Excel | |||
| How to rezize data label box in pie charts (label wraps to two lin | Charts and Charting in Excel | |||
| multiple addresses on one label sheet? | Charts and Charting in Excel | |||
| how to remove label formatting (eg label to number) | Excel Worksheet Functions | |||
![Spencer Hutton[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
