Set Range to a single column of a dynamic Range

How do I grab a column of a dynamic range:
Like
Set rng = index(  mySourceDynamic,, 2).cells

?


So for the second column of the dynamic range (C4:C19), setting a range to it, so that many things could be done to it…

Thank you
GrabColumnFromRange.xlsm
RayneAsked:
Who is Participating?
 
nutschConnect With a Mentor Commented:
e.g.

set rng=range("mySourceDynamic").columns(1)

as in

range("mySourceDynamic").columns(2).copy cells(5,8)
0
 
SteveConnect With a Mentor Commented:
OK, my fist advice... use Tables rather than named ranges.

Just highlight all your data anmd select Insert > Table

Then you can select ranges etc without having to do the funky naming thing.
GrabColumnFromRange.xlsm
0
 
RayneAuthor Commented:
Thank you for your feedback folks :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.