VBA 'GoTo' Buttons by variable increment

My query is detailed on the attached sheet, but in a nutshell ...

I have buttons that sent the cursor to different places in the 'A' column, by a step that was inserted in the coding (100, 200, 300, ...)

(The button labels are determined by the first three letters in a cell of that row, but that seems to be under control)

My wish is to make that step flexible, by having it reference a cell, so steps could be 125, or 150, or whatever.

Please Login or Register  to view this content.

Kind regards
Leo

Thank You Leo ...

This seems to be the code to do what I'm already doing ... here's what I've got -

Sub GoTo_A1017()
'
'GoTo_A1017 Macro
'

'
Application.Goto Reference:="R1017C1"
End Sub

Sub GoTo_A2017()
'
'GoTo_A2017 Macro
'

'
Application.Goto Reference:="R2017C1"
End Sub

I'm looking to make the 'R1017 & R 2017' step by a variable, rather than by the 'thousands I have 'hard coded' into the macro.

The value would be calculated as

reference;="R(17+Step_By*1)C1" and reference;="R(17+Step_By*2)C1"

I don't know how to incorporate that 'Step_by' variable into the row reference.

So, and where do we find this variable ?

It would be in a cell named "Step_By" which is D1 in my example

so change this A4, A7, and A10 to D1

OK I see ... I'll start in on that directly. Thank you

Here's the code that is doing what I was looking for ...

Sub GoTo_Step01()
Application.Goto Range("A" & 17 + 0 * Range("Step_By").Value)
End Sub

Thanks for the education on getting formulas and variables into VBA ... should help me in the long run.

Stay Well