title: Setting variables for sheets and ranges
body: <p>I am trying to make things easier on me when writing a macro for excel by storing things in variables, makes sense right? Well when i run the sub it is not happy, here is what i have:</p>
  
  <pre><code>Sub TransferPrices()
  
  
  ''*************************
  ''Variables
  ''*************************
  Dim Mon As Worksheet
  Dim Tue As Worksheet
  Dim Wed As Worksheet
  Dim Thur As Worksheet
  Dim Fri As Worksheet
  Dim Sat As Worksheet
  Dim Prices As Range
  Dim Discount As Range
  Dim todayDate As Date
  Dim sheetDate As Range
  
  ''Sheet Names
  Set Mon = Sheets("Monday prices")
  Set Tue = Sheets("Tuesday prices")
  Set Wed = Sheets("Wednesday prices")
  Set Thur = Sheets("Thursday price")
  Set Fri = Sheets("Frday price")
  Set Sat = Sheets("Saturday price")
  
  ''Prices
  Set Prices = Range("E11:E487")
  Set Discount = Range("G209:G356")
  
  ''Dates
  todayDate = Format(Date, "mm/dd/yyyy")
  Set sheetDate = Range("Sheet_Date")
  
  
  ''*************************
  ''Change dates on sheets
  ''*************************
  Mon.sheetDate = todayDate
  Tue.sheetDate = DateDiff(d, 1, todayDate)
  Wed.sheetDate = DateDiff(d, 2, todayDate)
  Thur.sheetDate = DateDiff(d, 3, todayDate)
  Fri.sheetDate = DateDiff(d, 4, todayDate)
  Sat.sheetDate = DateDiff(d, 5, todayDate)
  
  
  
  ''*************************
  ''Transfer prices from Saturday sheet to Monday sheet
  ''*************************
  Sat.Prices.Copy Mon.Prices
  Sat.Discount.Copy Mon.Discount
  
  
  
  
  ''*************************
  ''Clear other sheets
  ''*************************
  </code></pre>
  
  <p>End Sub</p>
  
  <p>When i compile the module on this line <code>Mon.sheetDate = todayDate</code> i get an error, Compile error: Method or data member not found on sheetDate. Can you not use <code>Mon.SheetDate</code> instead of <code>Mon.Range()</code> or am i missing something?</p>