Link to home
Start Free TrialLog in
Avatar of leezac
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
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Yes
It is the fourth column to the right of

r(1, 1)
Avatar of leezac
leezac

ASKER

So it is looking at column D?
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If the r(1,1) is in column A then the result will be in column E (four cells to the right)