[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 285
  • 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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