Use excel value to determine the VBA Offset parameter

[Nachtschade]

I have this little line of code:

Selection.Offset(-1, 0).Select

Now the -1 here needs to be variable, it could be either -1 or -2. I have a cell whose value determines that.

How do I implement that into the code?

 

[Dim Me as xlNoob]

Is the cell that holds this value always the same cell?

Set the variable in the code like this:

Dim x As Long

x = Range("A1").Value ' Change A1 to whatever the cell is that you want to reference

' Now you can reference the value from A1 where ever you need to

Selection.Offset(x,0).Select

 

[Nachtschade]

Thank you! That works like a charm.