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. |
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. |
All times are GMT +1. The time now is 11:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com