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

01-24-2025, 05:23 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,617

Thank you. I'm not sure how I would employ that method. I don't need the data displayed in a sheet. I need the row indexes for additional processing. E.g., in a larger process:

For lngIndex = 1 To oCol.Count 'Do some things. 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 08:23 AM.