On worksheet 'A' I have defined a Named Range that consists of 2 cells. On worksheet 'B' I would like to set 2 cells equal to the Named Range I defined on worksheet 'A'. I have been unable to figure out how to do this. I did try giving the 2 cells on worksheet 'B' a named range but can not figure out how to set 1 range equal to another without using code.
Thanks in advance!