Using a command button to update a cell value

[Adrian1]

Hi you clever people,

Could someone please tell me how I would make a command button do the following:

Make the value of merged cells b7:d7 equal the value of merged cells b6:d6 plus one?

When pressed, I want the button to populate cell range b7:d7 with the value plus one in (merged cells) b6:d6.

I hope this makes sense.

 

[north19701]

Private Sub CommandButton1_Click()
 Range("B7") = Range("b6").Value + 1
End Sub

I tried this, and it worked just using the first merged cell address.

 

[earlyd]

In general it's always a good idea to use range names when referring to cells in macros if you'll be modifying the spreadsheet. Macros don't adjust for relative references like spreadsheet formulas do. So if you insert a row above your data, the macro will no longer work.

 

[TryingToLearn]

I had a similar issue when dealing with merged cells in 97. Try this for kicks & giggles:

Private Sub CommandButton5_Click() 
Range(" b7").Value = Range("index1").Value + 1 
End Sub

 

[Juan Pablo González]

I *think* you could use

Range("index2")(1).Value = Range("index1")(1).Value