match not being found, when it is there

[Zygoid]

I am using this code to to search thru Col I of a worksheet, if a match is found it should place textbox values on the same row, but it is not. it is putting them on a new row as if the match cannot be found, but there is a match i use to see if i have the code right.

I am guessing it has to do with textbox1's value sometimes being a number (my test is 53953) and on the worksheet I get , col. I is formatted general, with some cells having all numbers(like my test) and other cells having numbers with letters like 345BC12.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Anyone know why?

[Leith Ross]

Hello Zygoid,

The problem is how you are referencing SrcRange when there is a match. Since Match returns the relative position in the array, and in this case that represents the row, you need to use the Item Property of a Range.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[Zygoid]

thanks Leith!