I couldn't get the row number based on my search value.

Hello All,

I am a new member to this forum. Please help me on the below issues.

findadjrow = ThisWorkbook.Sheets("sheet1").Range("D" & n & ":D" & findaggvalue).Find(What:="N", SearchOrder:=xlByRows).Row

I just wanted to get the row number based on the character "N" that available in the sheet1. The "N" available more than one occurrence in the sheet1, once I got the row number of "N", I have to perform some math operations. But the above code didn't return the row number of "N", instead it return the next row number.
I confirmed it through MsgBox function. Basically macro couldn't locate the value "N", but if append another character with N, like "NY" its working well. Please help me to fix this issue.

Thanks in Advance!

try including the LookAt argument, if you are trying to find cell that only contains "N"

lookat:=xlWhole

You need to post example workbook as the syntax works.
We need to see what's on the worksheet, what the values of n and findaggvalue are.

And I assume your post with Rowb as the return value is a typo?