Create macro to move formulas 1 column to right?

mmadrid

New Member
Joined
Sep 7, 2011
Messages
3
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!!
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,224,502
Messages
6,179,126
Members
452,890
Latest member
Nikhil Ramesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top