Delete matching cells

[Jim Cone]

Garry,
I wonder if gary (the original poster) is still around?
He would have his moneys worth by now. <g>

Its time for further posts, if any, on this subject to go into a brand new post.
It has gotten a little unwieldy.
'---
Jim Cone




"GS" <[email protected]>
wrote in message
news:[email protected]...

 

[GS]

I was thinking the same thing! I'll report back in a new thread as Jim
suggested...

 

[GS]

I like how you were able to eliminate the final If...Then construct.<g>

 

[gary]

Garry,
I wonder if gary (the original poster) is still around?
He would have his moneys worth by now. <g>

Its time for further posts, if any, on this subject to go into a brand new post.
It has gotten a little unwieldy.
'---
Jim Cone

"GS" <[email protected]>
wrote in message














- Show quoted text -

Yes, Gary (the OP) is still around.

Ron's macro gave me the results I was looking for! Thanks for all the
contributions!

Gary

 

[GS]

Uh.., I'm seeing that this approach raises a 'Type Mismatch' error in
the first loop where it loads colB into the collection.

Also, this approach empties colA and raises an error trying to write
the output array because the UBound(vColA) and lBlanks are the same
value.

What am I missing?

 

[Ron Rosenfeld]

Uh.., I'm seeing that this approach raises a 'Type Mismatch' error in
the first loop where it loads colB into the collection.

Also, this approach empties colA and raises an error trying to write
the output array because the UBound(vColA) and lBlanks are the same
value.

What am I missing?

If your data is numbers and not text strings, you can see that. Key has to be a string.

It is probably safest to always use Key:=Cstr(x)
That should have no affect on string data, but will convert numeric data to strings.

 

[Ron Rosenfeld]

Yes, Gary (the OP) is still around.

Ron's macro gave me the results I was looking for! Thanks for all the
contributions!

Gary

Glad to help. Thanks for the feedback.