Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheetfunction.match
I am trying to use worksheetfunction.match to get the data postion in a range named sheets("drawing").range("G2:G235") the code is Dim R as long Dim Trange as range Set Trange=sheets("drawing").range("G2:G235") R=application.worksheetfunction.match( 19031,Trange,0) Msgbox R ..... I am sure the no. 19031 mentioned above are in the range. But when I run this program, it appears err.number 1004. I can not get the R value please provide help. thanks Li Jianyong |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Re : Excel VBA and WorkSheetFunction (Match) | Excel Programming | |||
Application.WorksheetFunction.Match | Excel Programming | |||
Syntax for WorksheetFunction Match | Excel Programming | |||
worksheetfunction.match | Excel Programming | |||
Worksheetfunction MATCH | Excel Programming |