Offset vs. Range references
Typical expectation seems to be that reducing object "lookups" (ie. fewer
'dots' to get to the particular object) leads to better performance.
An example showing the two different methods you're considering would help.
Also -very easy to test...
Tim
"Howard Kaikow" wrote in message
...
Which may expected to be faster:
1. Using , as needed, e.g., Range, Cell and Cells objects to reference
cells.
2. Using Offset off of a Range object to reference a well established
pattern of cells.
It would seem that Offset should be faster, but is it?
Experiences?
References?
|