Match Function Wont Work in VBA

[Brendan_MS]

can anyone see what is wrong this this code?




Private Sub CommandButton1_Click()

Dim RangeTarget As Integer


RangeTarger = Application.WorksheetFunction.Match(ISS_ID_Menu, Sheets("Data_Master"), Range("Dyn_Date"), 0)

MsgBox RangeTarget



End Sub

[Phuocam]

Please insert the code in the code tag, [ code] Your Code [ /code] (or use the # button)

Try

Please Login or Register  to view this content.

[Trebor76]

Hi Brendan,

Welcome to the forum!!

Assuming Phuocam's solution works you've also misspelled your variable when trying to assign a value to it i.e. RangeTarger should be RangeTarget. Using Option Explicit would detect this.

Thanks,

Robert

[Brendan_MS]

Please insert the code in the code tag, [ code] Your Code [ /code] (or use the # button)

Try

Please Login or Register  to view this content.

Sorry Phuocam,

Im very new to VBA, could you give me an example of your suggestion above, I also have recognized that the variable was spelt wrong. I keep getting a
"complie error"
"wrong number of arguments or invalid property assignment"

I thankyou in advance

[jindon]

Please Login or Register  to view this content.