Hi
Use:
ActiveCell.FormulaR1C1 = _
=VLOOKUP(RC[-3],'[wrkbk.xlsx]Sheet1'!C1:C8,8,0)
Cheers
On Aug 25, 2014 4:18 PM, Nitin Balodi nitinbal...@live.com wrote:
Hi All,
I have two files: File1 and File2.
I need to apply Vlookup in File1 using references from File2.
I have stored
In order to understand what you're doing and work through your question,
you need to understand what VBA is doing.
Your VBA line:
ActiveCell.FormulaR1C1 = _
=VLOOKUP(RC[-3],'[ForecastLastUpdated_18 July 2014
15.45.xlsx]Sheet1'!C1:C8,8,0)
is essentially :
ActiveCell.FormulaR1C1 = some string
+0530
Subject: Re: $$Excel-Macros$$ VLookup file reference using VBA
From: v...@vabs.in
To: excel-macros@googlegroups.com
Hi
Use:
ActiveCell.FormulaR1C1 = _
=VLOOKUP(RC[-3],'[wrkbk.xlsx]Sheet1'!C1:C8,8,0)
Cheers
On Aug 25, 2014 4:18 PM, Nitin Balodi nitinbal...@live.com wrote:
Hi All,
I
],'[wrkbk]Sheet1'!C1:C8,8,0)
Value of WrkBk is *ForecastLastUpdated_18 July 2014 15.45.xlsx*
Regards.
Yours Sincerely,
*Nitin Balodi*
--
Date: Mon, 25 Aug 2014 16:25:31 +0530
Subject: Re: $$Excel-Macros$$ VLookup file reference using VBA
From: v...@vabs.in
Hi Vaibhav,
I had used this but it is still showing syntax error.
Regards.
Yours Sincerely,Nitin Balodi
From: v...@vabs.in
Date: Mon, 25 Aug 2014 17:45:09 +0530
Subject: Re: $$Excel-Macros$$ VLookup file reference using VBA
To: excel-macros@googlegroups.com
try:
ActiveCell.FormulaR1C1
Date: Mon, 25 Aug 2014 16:25:31 +0530
Subject: Re: $$Excel-Macros$$ VLookup file reference using VBA
From: v...@vabs.in
To: excel-macros@googlegroups.com
Hi
Use:
ActiveCell.FormulaR1C1 = _
=VLOOKUP(RC[-3],'[wrkbk.xlsx]Sheet1'!C1:C8,8,0)
Cheers
On Aug 25
Hi Paul and Vaibhav,
Thanks, it worked by giving spaces.
Regards.
Yours Sincerely,Nitin Balodi
Date: Mon, 25 Aug 2014 05:45:45 -0700
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ VLookup file reference using VBA
To: excel-macros@googlegroups.com
The syntax error is probably because
nitinbal...@live.com
*To:* excel-macros@googlegroups.com excel-macros@googlegroups.com
*Sent:* Monday, August 25, 2014 7:46 AM
*Subject:* RE: $$Excel-Macros$$ VLookup file reference using VBA
Hi Vaibhav,
Thanks for immediate response, but it is still showing me Syntax Error