Runtime Error 1004 and Runtime Error 13

'ISSROWTARGET should return the row of the selected from ISS_ID_DD_Combo box'
'Dyn_Range is a dinamic range =OFFSET(Data_Master!$B$6,0,0,Engine!$D$2,1)
'The range for the interger atm is 5 lines'
'This results in a Runtime Error 1004 ISSROWTARGET = Application.WorksheetFunction.Match(ISS_ID_DD_Combo, Sheets("Data_Master").Range("Dyn_Range"), 0)'
'This results in a Runtime Error 13 ISSROWTARGET = Application.Match(ISS_ID_DD_Combo, Sheets(4).Range("Dyn_Range"), 0)

Private Sub CommandButton1_Click()



Dim ISSROWTARGET As Integer


ISSROWTARGET = Application.Worksheetfuction.Match(ISS_ID_DD_Combo, Sheets("Data_Master").Range("Dyn_Range"), 0)



MsgBox ISSROWTARGET

End Sub

Hi there,

A value read from a ComboBox is a string value, and you're trying to compare it with a numeric value in the worksheet.

See if using the following line of code helps:

ISSROWTARGET = Application.Worksheetfuction.Match(CInt(ISS_ID_DD_Combo), Sheets("Data_Master").Range("Dyn_Range"), 0)

Hope this helps - please let me know how you get on.

Regards,

Greg M

Greg you are an absolute legend I have been struggling with this for 3 days, I did suspect that was the problem but couldn't find how to change the properties from text to Numbers.

Again Thankyou

Hi again,

Many thanks for your very prompt feedback.

You're welcome - glad I was able to help.

Regards,

Greg M