title: Excel VBA - How to change a cell reference to the second last and last column
body: <p>My first column consists of the currency names and the column data are monthly exchange rates (with the first row as month names).</p>
  <p>Every month, I add a new column with the latest exchange rates. I need to amend the cell references of last month's rate and this month's rate to the second last and last column of the sheet. Is there any code for this?</p>
  <p>Thank you</p>