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

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?


 
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:25 AM.

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"