Use a variable to find and name another.
Posted on 2014-08-06
I have a variable named SurfCH_Value
What I need to do is in column M, find the cell that has its value in it. Then when that is found, (will be there everytime) I need to assign another variable to the value of the cell that is offset 4 cells from that to the right. Naming that variable CH_FixedValueForSurf
I need to use this name later in the procedure... new to the naming of items within VBA to use later.. opening up a lot more understanding of how to use and write subs.