WorksheetFunction.Match cannot find what "=match()" formula can find in worksheet

[ironny90]

Hi there! I am trying to find a date Mar-22 in an excel sheet. The column starts with 1/31/2022 and goes down with "=eomonth()" formula. Mar-22 is calculated as "=eomonth(A2,1)" and format is date.

I tried to use Ctrl + F to find the date (tried 3/31/2022, 03/31/2022, 44651, etc.), but didn't succeed. I used "=match()" formula to search 44651, the date serial, and succeeded.

Now I am trying to use worksheetfunction.match in vba to find that cell (with 44651), but it didn't find anything.

My goal is to find that cell and activate the row in vba. Can anyone help? Thank you!!!

 

[ironny90]

Hi Jason! Thank you for your quick response! I just posted this. My goal is to use vba to activate the row that cell is in. Can you help with vba as well?

Hi there! I am trying to find a date Mar-22 in an excel sheet. The column starts with 1/31/2022 and goes down with "=eomonth()" formula. Mar-22 is calculated as "=eomonth(A2,1)" and format is date.

I tried to use Ctrl + F to find the date (tried 3/31/2022, 03/31/2022, 44651, etc.), but didn't succeed. I used "=match()" formula to search 44651, the date serial, and succeeded.

Now I am trying to use worksheetfunction.match in vba to find that cell (with 44651), but it didn't find anything.

My goal is to find that cell and activate the row in vba. Can anyone help? Thank you!!!

 

[Peter_SSs]

Duplicate to the continuation of this thread: Ctrl + F can't find value in date format; eomonth formula used

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.