Other folks here may give you a VBA macro that'll do the job for you, mapl. The only guidance I'll offer you is help in making you not nil at authoring one. That is, if you want to learn how to write a macro to do it, I'll spend time coaching you. The advantage is that afterward you'll actually know how it works, can fix it if you need to or enhance if you want to, and write another one some time in the future. I'm all for that. But if you just want a working macro, I'll let someone else do it.
|