Endless loop?

[STEVE BELL]

John,

I forgot to add .row
Without .Row Excel doesn't know what you want...

rw2 = Sheets("NI").Range("A9").End(xlDown).Row + 1

and you were correct to delete rw1 = 0...

 

[John]

Steve, thanks for all the help. I really like the qualifications on the find
function.

 

[STEVE BELL]

John,

Glad to have helped! Thanks for the feed back.

One thing I do is to experiment in Excel with the Macro Recorder on.
That's how I found the Find code for you...

 

[John]

very cool, nice job again.

John,

Glad to have helped! Thanks for the feed back.

One thing I do is to experiment in Excel with the Macro Recorder on.
That's how I found the Find code for you...

 

[STEVE BELL]

John,

Keep on Exceling....