How to assign a variable value in to another variable

[chakkrav]

Hi All, how do i get the variable c address in my variable rng
dim r as range, c as string
c = Activecell.Entirecolumn.Address (False,False)
rng = Intersect(Range("C"),Activesheet.usedrange
It is throwing an error for variable rng
:(

[Paul_Hossler]

Maybe



dim r as range, c as string

c = Activecell.Entirecolumn.Address (False,False)

Set rng = Intersect(Range(C),Activesheet.usedrange)






But I'd use






Set rng = Intersect(ActiveCell.EntireColumn, Activesheet.UsedRange)

[chakkrav]

Thanks Paul :)