I've been scratching my head for the last couple of days with a Visual Basic problem and was hoping for some help.

I have a spreadsheet in Excel with a hundred and so rows of data and each cell has a reference to another spreadsheet it feeds its information from. For example, the data in column B16 of my spreadsheet is populated by its cell reference to this other spreadsheet.

I've been trying to write a macro which changes the cell references (i.e. A20) by going two letters up in the alphabet. So A20 would become C20, B12 would become D12, etc). The macro needs to be able to amend the cell reference formulas this way, if it's possible. So in the end the macro would run this in a loop and save copies of various spreadsheets and save them with a identifiable filename. I have everything working but the cell reference bit.



Any help would be much appreciated.