chakkrav
10-20-2018, 06:22 AM
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
:(
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
:(