Excel VBA Match function

Question

A Match.Evaluate function in my codes doesn't work unfortunately.

Below you can see the formula:

Worksheet_Bilgiler = "Egitim Bilgileri"
Ders_Adi = "Deneme1"

Ders_Satir_bul = Worksheets(Worksheet_Bilgiler).Evaluate("=Match(" & Ders_Adi & ", '" & Worksheet_Bilgiler & "'!C:C, 0)")

MsgBox Ders_Satir_bul

Can you guys help me?

score 1 · Accepted Answer · answered Sep 25 '17 at 07:27

1

You need to add double quote sign " before and after your Ders_Adi variable. You can do that by using Chr(34).

Change your Evaluate line to :

Ders_Satir_bul = Worksheets(Worksheet_Bilgiler).Evaluate("=Match(" & Chr(34) & Ders_Adi & Chr(34) & ", '" & Worksheet_Bilgiler & "'!C:C, 0)")

answered Sep 25 '17 at 07:27

Shai Rado

33,032
6
29
51

Thank you so much man. Worked like a charm! – Bildircin13 Sep 25 '17 at 07:33
@Bildircin13 you're welcome :) – Shai Rado Sep 25 '17 at 07:38
Just a tip, `Evaluate` can be reduced to **`[Formula]`**, for example `[SUM(Sheet1!A1:A10)]` – AntiDrondert Sep 25 '17 at 07:54

Excel VBA Match function

1 Answers1