leezac

asked on

# Offset column reference

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

If r(1, 1).Offset(0, 4) = 0

If r(1, 1).Offset(0, 4) = 0

Yes

It is the fourth column to the right of

r(1, 1)

r(1, 1)

ASKER

So it is looking at column D?

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

If the r(1,1) is in column A then the result will be in column E (four cells to the right)