Vba code for concatenate, vlookup

[SURYAKANTHAREDDY]

Hi Sir,

I am beginner in excel macro. I am able to use the macro recording. In recording we will get the formulas as is So, instead of that I want define VBA codes. So, Please help me defining the below formulas,

=CONCATENATE(C2,"-",D2)

= VLOOKUP (G2,'MASTER TEMP TL'!E:E,1,0)

= VLOOKUP(A2,'MASTER TEMP TL'!B:B,1,0)

Note : VLOOKUP need to search data in other sheet. So, here MASTER TEMP TL is sheet name.

 

[Charleton]

Hello,

You can make a vlookup the result of a variable or cell reference by the Application.WorksheetFunction.VLookup Method

https://msdn.microsoft.com/en-us/vb...okup-method-excel?f=255&MSPPError=-2147217396

For concatenation you just add variables, strings, or cell references. If you limit the use of ranges by using Cells(1, 1) instead Range("A1") type cell references, you save a lot of memory on larger projects:

Sub Concatenate()
' This Sub will fill Cell E2 with the value of the formula CONCATENATE(C2, "-",D2)


Cells(2, 5) = Cells(2, 3). & "-" &  Cells(2, 4)


End Sub

Hope this helps!