Posted to microsoft.public.excel.programming

Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline

external usenet poster

Posts: 1,045

Addressing ranges

Dim c as Range

Assuming c is a single cell range, and I want to write a value into
the adjacent column, is there any advantage/disadvantage to using

c.offset(0,1)
vs
c(1,2)

??

c(1,2) is more compact.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Addressing in VBA	Richard	Excel Discussion (Misc queries)	1	January 23rd 08 01:40 AM
VBA and range addressing	C Brandt	Excel Discussion (Misc queries)	3	July 31st 07 04:38 PM
Cell Addressing	John Calder	New Users to Excel	3	March 9th 07 12:32 PM
Relative Addressing	Bill Martin -- (Remove NOSPAM from address)	Excel Discussion (Misc queries)	4	February 20th 05 04:43 AM
Addressing a group of Named Ranges	Mike Fogleman	Excel Programming	5	May 18th 04 02:43 PM

All times are GMT +1. The time now is 12:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us