title: VBA change value in another workbook
body: <p>I need some help changing variables in another workbook.</p>
  
  <p>First I open the workbook with <code>Workbooks.Open ("test.xlsx")</code></p>
  
  <p>When I try to change a cell value with <code>Workbooks("test.xlsx").Worksheets("Sheet").Cells(1, 1).Value = VariableX</code> it gives me error 9: subscript out of range. I don't see why it won't work. Can anyone help me out on this?</p>