Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-12-2021, 07:08 PM
SamDsouza SamDsouza is offline Subscript out of Range Error when searched for string and its line number in Text File Windows 10 Subscript out of Range Error when searched for string and its line number in Text File Office 2013
Advanced Beginner
Subscript out of Range Error when searched for string and its line number in Text File
 
Join Date: Aug 2019
Posts: 71
SamDsouza is on a distinguished road
Default

GMayor Sir,



Indeed valuable inputs. Thank you so much for the help you have provided and derive the results in two different objects.

Last question How can i define a blank line as string. Although vbCr , vbCrlf are predefined. One can see the 1st and 2nd Structure of text file in #3

Thank you so much

SamD
Reply With Quote
Reply



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
Subscript out of Range Error when searched for string and its line number in Text File 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 when searched for string and its line number in Text File Subscript out of range error KHTAY Excel 6 03-28-2009 11:18 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:20 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft