Offset vs. Range references

  • Thread starter Thread starter Howard Kaikow
  • Start date Start date
H

Howard Kaikow

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?
 
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
 
Tim Williams said:
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...
Click to expand...

My expectation is that Offset would be faster because there would be less
object lookups/assignments.

Performance difference would depend on the particular algorithms used and
coding skills.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Named Range maker code 9
Clean this select case code up a bit. 2
Dynamic Offset from an Application.Goto cell = Date or Time 10
Copy to a mid column range Row 10 - Row 20 4
OFFSET LOOKUP function in VBA? 9
Using =Offset in Charts 1
Cell references and merged cells 2
.cells reference? 1

Back
Top