Display Search Term by Column and Row Number

[Logit]

.
Thank you for reviewing this conundrum.

Trying to search for a term on a separate sheet, once located , return the row number.

Using the row number ... add that to the column (ex: H10) ... then use that to return its value
to a cell in the original sheet (B10 & B11). Ultimately there will be many more values to return
to the original sheet.

The macro below works for just displaying the cell location in a MsgBox. When adding the next step
to display the cell value in the original sheet .... the macro crashes.

Please assist

ps: I'd rather not use formulas for this portion of the project.

Please Login or Register  to view this content.

[Fluff13]

It's because you entered a permanent loop, try

Please Login or Register  to view this content.

Every time B10 changes the changeevent kicks-in again

[Logit]

.
Thank you again Fluff.

You are a good friend !

[Fluff13]

My pleasure & thanks for the feedback