find row no. of particular cell in a range and find last entry in that row

hey guys..i have an existing database and i'm using a user form to make further entries in that database..each existing entry has a unique ID no..i want to search that ID no. which is in Column "O" and then find the last entry in that cell's row so that i can make further entries..to find the id i am using the following code..bt m stuck on how to get the row no. of the cell which the id the user has selected..if i hv the row no. i can use CountA to find a blank cell in that row..

Please Login or Register  to view this content.

Thanks..

If you want your function to return the row number instead (?):

Please Login or Register  to view this content.

Now that 'searchIssue' has the row number..i wanted to make entries with the following code :

Please Login or Register  to view this content.

emptyCol contains the column number of the blank column available..

But this is giving me "compile error:argument not optional" msg..