vba - Assigning cells to variables -
i have set cell variable , have stored cell address within variable:
dim sumoflevel string sumoflevel = activesheet.range("e" & rows.count).end(xlup).offset(, 5).address
i want populate cell , can't seem work. have tried numerous techniques example:
sumoflevel.value = "getting there"
there 2 ways can address problem.
way 1
dim sumoflevel string sumoflevel = activesheet.range("e" & _ activesheet.rows.count).end(xlup).offset(, 5).address activesheet.range(sumoflevel) '~~> .value = "getting there" end
way 2
dim sumoflevel range set sumoflevel = activesheet.range("e" & _ activesheet.rows.count).end(xlup).offset(, 5) sumoflevel '~~> .value = "getting there" end
Comments
Post a Comment