Macro to update formulas in multiple cells.

Could anyone help my out with a macro?

I have a spreadsheet with cells that contain the following formula or similar: "=+'anothertab'!A27"

I am looking for a button that when clicked, will add 8 to the following cells: C6, D6, C8, D8, C14, and D14
and then/also add 1 to the following cells: C17, D17, E26, E27, E34, E35

For example, if cell C6 contained "=+'anothertab'!A27", the result after pressing the button would be "=+'anothertab'!A35"
Likewise, if Cell C17 contained "=+'anothertab'!B27", the result after pressing the button would be "=+'anothertab'!B28"


Currently, I have them all updating by individual buttons, but I would like one button to update all the cells at once. Any help is much appreciated. Thanks!

Here is sample code for the button to add 8. The problem with this code is that I have to have the cells that I want changed by the button
highlighted before the button is pressed. I would like the button to automatically change the cells I listed without having to select them.

Please Login or Register  to view this content.

I think I could modify that code by changing the "Set R" property to something other than 'selection'?