Subscript out of Range Error when searched for string and its line number in Text File

gmayor · #1 01-11-2021, 05:32 AM

Your code works here, assuming that the text file in question is compatible with the search pattern e.g.

Name "John Smith"
Age "27"
Date of Birth "12/12/1993"

would show you 12/12/1993 in the message box.

SamDsouza · #2 01-11-2021, 07:38 AM

This is the following structure of the original txt file:

Quote:

Name Tom
Age 13

Name John
Age 15

Name Jack
Age 16

Name Michael
Age 12

Hey as per your format i quickly changed the Data of Text File to:

Quote:

Name "Tom"
Age "13"
DOB "27/12/1993"

Name "John"
Age "15"
DOB "15/12/1991"

Name "Jack"
Age "16"
DOB "05/08/1990"

Name "Michael"
Age "12"
DOB "25/02/1994"

Name "Martin"
Age "33"
DOB "30/12/1980"

Name "George"
Age "43"
DOB "15/12/1970"

1. Yes indeed it reads the 1st date but does not move on further and reads the other dates in msgbox

Another observation
2. for Eg if WhatToFind ="Name" then its First Record will show the Value of Age =13 rather than "Tom"
if WhatToFind ="Age" then its First Record will show the Value of Date 27/12/1993

SamD

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Declare wBk as workbook. Set wBk = workbooks("NewBook.xls") gives error: Subscript out of range.	Syed Shabbir	Excel Programming	1	09-27-2020 09:35 AM
replace with text contains a group number which is out of range Error Message	raghugada	Word	6	05-30-2017 02:09 PM
Runtime error '9': Subscript out of Range	KingoftheKassel	Excel Programming	1	06-13-2016 08:00 PM
VBA Conditional Formatting Error (Subscript out of Range))	tinfanide	Excel Programming	1	05-15-2015 08:12 AM
Subscript out of range error	KHTAY	Excel	6	03-28-2009 11:18 PM