• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 287
  • Last Modified:

Offset column reference

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

If r(1, 1).Offset(0, 4) = 0
0
leezac
Asked:
leezac
  • 4
1 Solution
 
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:
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:
If the r(1,1) is in column A then the result will be in column E (four cells to the right)
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now