Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 269
Default Offset vs. Range references

"Tim Williams" <timjwilliams at gmail dot com wrote in message
...
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...


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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
OFFSET and external workbook references Dave F[_2_] Excel Discussion (Misc queries) 3 October 25th 07 04:36 PM
OFFSET() function with external references braultg Excel Programming 3 August 18th 06 01:16 PM
Incorporating OFFSET into Chart References Chris Excel Worksheet Functions 1 August 17th 06 05:36 PM
OFFSET function returning #VALUE when using external references AndrewPace Excel Worksheet Functions 2 April 12th 06 06:37 PM
Offset References gthull644 Excel Discussion (Misc queries) 3 May 29th 05 02:06 PM


All times are GMT +1. The time now is 07:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"