Link to home
Start Free TrialLog in
Avatar of Rayne
RayneFlag for United States of America

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of nutsch
nutsch
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Steve
Steve
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Rayne

ASKER

Thank you for your feedback folks :)