Macro Buttons

[SaraWitch]

Hello everyone,

I have a couple of macro buttons that go to a specific cell further down the worksheet when clicked. However, if rows are added and deleted, the range doesn't change with the updates and I want to be able to select the original range regardless of row changes. Hope that makes sense! I'm using the following code in VBA:

Sub RoundedRectangle1_Click()​

ActiveSheet.Range("B10").Select​

End Sub​

I'm sure there's a simple way of doing it, but I just can't figure it out! I've tried absolutes, but, of course, they don't work.

Any help would be appreciated...

 

[jmacleary]

Hello there. In Name Manager define a name for your cell (I used a silly one - BeeTen)
Then this code works:

Sub RoundedRectangle1_Click()
ActiveSheet.Range("BeeTen").Select


End Sub

 

[sykes]

You could use named ranges for your cells.
I named "B10" on a sheet "test" then added rows & columns, but the named cell was still activated with each button press:

Private Sub CommandButton1_Click()
Me.Range("test").Select
End Sub

 

[SaraWitch]

Works a treat! Thank you, both

 

[sykes]

Pleasure! Thanks for the feedback.

 

[jmacleary]

You're welcome and thanks for the feedback.