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

Mark Forums Read

Thread Tools

Display Modes

01-24-2025, 06:18 AM

p45cal

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

Office 2021

Expert

Join Date: Apr 2014

Posts: 962

change:

Code:

Set oRng = .Cells.Find(What:="Pears")

to:

Code:

Set oRng = .Cells.Find(What:="Pears", after:=.Cells(.Cells.Count))

The default place .Find starts looking is after the first cell in the range it's searching, which is the 2nd cell).
The adjustment makes it start searching after the last cell in that range, so it starts searching from the first cell in the range.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 01:27 AM.