Return row index of all cells where text is found.

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Return row index of all cells where text is found.

FAQ

Thread Tools

Display Modes

#10

01-25-2025, 10:59 AM

gmaxey

Windows 10 Return row index of all cells where text is found.

Office 2019

Expert

Join Date: May 2010

Location: Brasstown, NC

Posts: 1,598

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/

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel VLOOKUP - Return cells that are not blank from range of specified cells	djlw84	Excel	10	05-09-2022 11:59 AM
Index Match and return mutiple results from a table	Bosslb	Excel	7	09-25-2021 11:42 PM
need Index, Match, Max to return SUMPRODUCT?	IRHSAM	Excel	0	11-17-2017 09:48 AM
Index to return value based on 2 conditions	george batshon	Excel	2	01-28-2017 05:11 AM
find a set of characters in a string and return a 0 (zero) if not found	MaineLady	Excel	2	11-05-2015 03:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:19 PM.