I have a variable that gets assigned a cell number in VBA via the activecell.address. I have another variable that needs to be the same column as the first variable, BUT 1 row down.

For example if Variable1 = M3, I need Variable2 to be M4. I have tried a number of ways, but coming up with nothing that works.

Any thoughts, current code below where variable1 (Vnd) is getting it's value, variable2 name is StC... not shown in code because I have not had any luck with getting it to work so that StC would Equal M4 (in this case)

This code will be used in a number of different workbooks, so the M column will not always be the same in every book.

Vnd = ActiveCell.Address(0, 0)
Thank You.