title: Fill array with range from different worksheet
body: <p>In a function I define my array like below but the function gives me #value when I use it in the worksheet. It works when I leave the part Worksheets("interestrates")., however, in the wrong sheet then. What can I do, to tell Excel to fill the array with values from the worksheet "interestrates"</p>
  
  <p>array1 = Worksheets("interestrates").Range("a" &amp; range1.Value &amp; ":c" &amp; range2.Value)</p>