Link to home
Start Free TrialLog in
Avatar of hindersaliva
hindersalivaFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Excel VBA - reference a range within a Named Range

I have a Named Range "myRange" which refers to "C10:G20"

What would be the coolest way to refer to the left-most column of the range? (Which would return "C10:C20")
ie. Range("myRange"). ????

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Norie
Norie

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 hindersaliva

ASKER

Ah yes, Norie. Simple. Thanks.