Assign a variable a cell number based off off another variable that is assigned a cell num

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.

Please Login or Register  to view this content.

Thank You.

Like this?

Please Login or Register  to view this content.

Thank you Kyle, I added the (false, false) to get rid of the $ absolute values and it works fine, I apprec.

Please Login or Register  to view this content.