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, 07:26 AM

batman1

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

Office 2013

Advanced Beginner

Join Date: Jan 2025

Posts: 57

I would change it to (don't use On Error... ONLY to exit Do... Loop)

Code:

If Not oRng Is Nothing Then
    FirstAdd = oRng.Address
    Do
        oCol.Add oRng.Row, CStr(oRng.Row)
        Set oRng = .FindNext(oRng)
    Loop While oRng.Address <> FirstAdd
End If

« 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 03:57 PM.