Create macro to move formulas 1 column to right?

[mmadrid]

Hello,

I'm new to this VBA language and I am struggling with the updating of formulae in code. Can anyone help?

I have formulas in a workbook that refers to another sheet in a different workbook (master spreadsheet).
Hello,

The formulae looks like this:

='sheet 1'!BH32

So in the VBA code I need to update the formulae each month to refer to the next cell along i.e. if the reference is to cell BH this week I need it to be changed to cell BI nextmonth in the workbook using code.

I am able to do a find and replace and also recorded the macro using the find and replace for all the formulas. All formulas are similar, the BH needs to be changed to BI, this month and BJ next month.

So I have the marco recorded, but now I need to revise the macro section that changes the BH to BI to something that will change it to one column to the right.

Any suggestions!!

 

[craig.penny]

Can you post the code you want to revise?

 

[mmadrid]

Sorry I have no code, It is just the formulas in this need to be change from BH32 --> BJ32, BH33 ---> BJ33 and there are like 100 of these.

 

[craig.penny]

You're in the same situation as from a year and a half ago? Wow!

You said you recorded code and that you needed to revise a section of it. I'm asking you to post whatever code you recorded that you're using now.