Thread: Return row index of all cells where text is found.
View Single Post
 
Old 01-25-2025, 10:59 AM
gmaxey gmaxey is offline Windows 10 Office 2019
Expert
  
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,598
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default
Yes, still 2019. Sorry.


I just need to loop through the indexes. So if the word "pear" is in rows 2, 3 and 6



For lngIndex = 1 To oCol.Count Debug.Print oCol.Item(lngIndex) 'Should print 2, 3 and 6 Next
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote