i'm doing first excel vba project , having trouble. i'd value in cell in currentbalance column. i'll using activecell.row row number. , i'd use named range column in case need insert additional columns later.
so i'd have is: balancevariable = "currentbalance"$activecell.row
i've been trying things hour , can't work. i've tried range , cell , othe things. suggestions?
currentbalance named range.
sub test() dim balancevariable double balancevariable = cells(activecell.row, range("currentbalance").column) msgbox "the current balance " & balancevariable end sub 
