title: VBA multiply two named ranges
body: <p>I've been trying to look this up everywhere and I can't seem to find the answer or get it to work.</p>
  
  <p>I have the code</p>
  
  <pre><code>'Define Variables for cell ranges'
  Dim BidItem As Range
  Dim BidItemDes As Range
  Dim BidItemUnit As Range
  Dim BidItemQTY As Range
  Dim BidItemUP As Range
  
  'Store the sheet range into the variables'
  Set BidItem = Sheets("BidItems").Range("A1:A" &amp; Range("A1").End(xlDown).Row)
  Set BidItemDes = Sheets("BidItems").Range("B1:B" &amp; Range("B1").End(xlDown).Row)
  Set BidItemUnit = Sheets("BidItems").Range("C1:C" &amp; Range("C1").End(xlDown).Row)
  Set BidItemQTY = Sheets("BidItems").Range("D1:D" &amp; Range("D1").End(xlDown).Row)       
  Set BidItemUP = Sheets("BidItems").Range("E1:E" &amp; Range("E1").End(xlDown).Row)
  Set BidItemValue = Sheets("BidItems").Range("F1:F" &amp; Range("F1").End(xlDown).Row)
  
  Set BidItemValue = Sheets("BidItems").Range("F1:F" &amp; Range("F1").End(xlDown).Row)
  </code></pre>
  
  <p>What I need to do is have all the data in range BidItemQTY and Multiply it by the range BidItemUP
  and then output that answer to the range BidItemValue.</p>
  
  <p>I have the last line of code setup to start the function but
  I can't seem to grasp on how to do math functions in VBA with Variables. </p>