Home |
Search |
Today's Posts |
#1
|
|||
|
|||
application.match and value problem
Have a "data" worksheet,
Column A contains the Item Number with column set to text Dim val As String With userforms1 val = Itemnum.Value If IsError(Application.Match(val, Range("price").Columns(1), 0)) Then If I enter the item number manually all works. If I copy and paste values from another worksheet that is e-mailed to me every 3 months with new item numbers and pricing Application.Match will not work. Help please ThaNKS cARL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office application version does not match. | Excel Discussion (Misc queries) | |||
How do I set up Data entry to match My Application Form | Excel Discussion (Misc queries) | |||
application.match | Excel Discussion (Misc queries) | |||
Problem with application.Hlookup | Excel Discussion (Misc queries) | |||
Application.WorksheetFunction.Match problem | Excel Worksheet Functions |