Try this
range("a1")= worksheetfunction.vlookup(range("b1").value,workbooks("File
name.xls").worksheets(Sheetname).Range("Select table"),2,0)
On Thu, Aug 27, 2009 at 12:44 PM, Sanjay Singh
wrote:
> Hi Everybody,
>
> Can you please help me with the below formula
>
> Thanks and Regards
>
> Sanjay
Test
On Thu, Aug 27, 2009 at 1:17 PM, vivek agrawal wrote:
> it prompts because it needs the SAP Records worksheet to be opened when it
> executes the statement...
> excel checks all the open workbooks and tries to find the workbook
> referenced hence you need to keep the workbook open befor
it prompts because it needs the SAP Records worksheet to be opened when it
executes the statement...
excel checks all the open workbooks and tries to find the workbook
referenced hence you need to keep the workbook open before executing the
sub procedure
hope this helps
Thanks and Regards,
V
Hi Everybody,
Can you please help me with the below formula
Thanks and Regards
Sanjay Singh
On Tue, Aug 25, 2009 at 12:44 PM, Sanjay Singh
wrote:
> Hi Everybody,
>
> I need help with below Vlookup function in macro.
>
> Following is the code I am presently using
>
> ActiveCell.FormulaR1C1 = "=
