![]() Now, you will get the column position of this student.įinally, you will get the row position of this student’s name. In case the string is not matched up in the data range, then it will return “Not found”.Īfter that, you will get the following Message Box containing the cell position of the student named “Daniel Defoe”. Here, rng is declared as a range object, and “ without optional parameter” is the name of the sheet.Īfter finding “ Daniel Defoe” in the data range it will return the cell address, column number, and row number of this string in the Message Box. Set rng = Sheets("without optional parameter").UsedRange.Find("Daniel Defoe") ➤Write the following code Sub SimpleFind() Then, the Visual Basic Editor will open up. ![]() ➤Go to Developer Tab> Visual Basic Option ![]() ![]() To find the position of this student’s name in the data table you can follow this method. Here, I will find the student’s name marked by a red box, Daniel Defoe, in the Student Name column. Method-1: Finding String Without Optional Parameter I will explain different ways to find and replace any data by using this table with the help of VBA.įor this purpose, I have used Microsoft Excel 365 version, you can use any other versions according to your convenience. I have used the following table which has the records of results of some students.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |