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.
|