View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default 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.