Hi all,
I have some code that needs to refer to ranges a fair bit and was
wondering if there are any differences speed wise between
(a) referring to named ranges ie.
x = range("Name")(j,i).value
and
(b)actually setting a range equal to a named range in the code ie.
set MyRange = range("Name")
x = myrange(j,i).value
is there even any difference at all between these two methods? I was
wondering if once set it would be faster to get values from MyRange
than to get them from range("Name"), if this is true there must be some
overhead in setting MyRange. So there must be a point after accessing
the range a number of times where setting MyRange becomes more
efficient.
I can test all this for myself but was just wondering if anybody could
give me some info first as to whether I would be wasting my time.
kind regards,
Tim
Bookmarks