Application.Match problem

Giganews Newsgroups
Subject: Application.Match problem
Posted by:  elamrani.logiso‚Ķ@gmail.com
Date: Sun, 26 Jul 2015

Sorry for bothering you i'm new in VBA =20
I am trying to use the MATCH function in VBA to search for a particular hou=
r in a range containing hours and return the matching column number
that give me Error N=B013 so thank you for your help=20

Public Sub test()
With Sheets("F. Regulation") =20
Dim dt As Double
dt =3D Sheets("Standard d'engagement").Cells(3, 4)
A =3D Application.Match(CLng(dt), Range("B2:EP2"), 0)
MsgBox (A)
End With
End Sub

Replies