VBA Loop Macro Fix for search code

[Jockney]

I've a problem with some code, I think this is running on an eternal loop but can't figure this out. Please can someone have a look at let me know what they think the problem is. It's a simple lookup and loop code but I seem to have got it wrong. I've now been staring at it for the past two days and I'm flying the white flag.

Please Login or Register  to view this content.

Thanks in advance

[arlu1201]

Why this -

Please Login or Register  to view this content.

You can use

Please Login or Register  to view this content.

[Jockney]

With

Please Login or Register  to view this content.

It should allow the the code to figure out how long it needs to be. I orignally thought this may have been the issue as well but this column is simply text based so there's no forumlae to interfer with this count. I'll have a play about with your suggestion and will let you know the outcome.

---------- Post added at 12:44 PM ---------- Previous post was at 12:37 PM ----------

Ok, I've tried your suggestion and now I'm facing a mismatch error. I've made the *after* section into a range. This is the last cell of the column which is being searched. I really can't see what is going wrong with this

Please Login or Register  to view this content.

Any ideas?