Next empty cell from found cell

[Rob K]

Hi there,

In this spreadsheet, I am using "Find" to find a part number, which are in rows, and assigning it to a variable and I want to find the next cell in that row. I can find a cell from a known cell like this:

Please Login or Register  to view this content.

But on this occasion I am using my search variable. I tried this:

Please Login or Register  to view this content.

But of course it doesn't work.

"BatchSearch" is just a variable that is assigned as Range and returns a cell address. Can someone give me the correct syntax for this, or show me a better way to do it.

Kind regards
Rob

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Rob K]

Absolutely spot on, thank you so much, this has been plaguing me for hours!

Cheers
Rob

[Norie]

Perhaps.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.