Negative relative reference in R1C1 Formula inside vlookup

x = 2

Set R = Range(Cells(2, x + 2), Cells(z, x + 4))
Worksheets(1).Cells(2, x) = "=vlookup(RC[" & 1 - x & "]," & R.Address & ",2,0)"

I am facing issue with the above code. I am intending to run this in a loop with x increments in steps of 2. If I manually give any value in place of RC[" & 1 - x & "] then it works which hints that only that part going wrong.

Anyone can offer a quick help?

You are combining A1 and R1C1 references in that formula, which is why it fails. Try:

Please Login or Register  to view this content.

Originally Posted by contactfornitish

Somehow your suggestion worked. Trying to understand theory behind that how it happened though

I explained why in my last post.

Originally Posted by rorya

I explained why in my last post.

Got stuck again. Can you help that what going wrong with below code

Please Login or Register  to view this content.

What is happening?

Its giving Run-time error '1004', Application-Defined or Object-defined error and debug is taking to this line.

Uploading the Macro enabled file
https://drive.google.com/file/d/0B_r...ew?usp=sharing

The pre-requisites are:
C:\temp and D:\Ping folders need to be there and the below csv files would be in D:\ping which would be processed into a report at c:\temp
https://drive.google.com/file/d/0B_r...ew?usp=sharing
https://drive.google.com/file/d/0B_r...ew?usp=sharing

Just a space in last vlookup created whole headache