Offset column reference

Is the 4 in the code below looking at a column?

If r(1, 1).Offset(0, 4) = 0
leezacAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
It is the fourth column to the right of

r(1, 1)

if r(1, 1) is one cell the offset will return the fourth cell to the right of r(1, 1)

if r(1, 1) is more than one cell the offset will return the same size four cells to the right of the first cell in r(1, 1).
0
 
Saqib Husain, SyedEngineerCommented:
Yes
0
 
Saqib Husain, SyedEngineerCommented:
It is the fourth column to the right of

r(1, 1)
0
 
leezacAuthor Commented:
So it is looking at column D?
0
 
Saqib Husain, SyedEngineerCommented:
If the r(1,1) is in column A then the result will be in column E (four cells to the right)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.