"Nasir" wrote in message
...
On Mar 6, 5:15 am, "Clif McIrvin" wrote:
"Clif McIrvin" wrote in message

...

[...]

I cannot make it work
There are three differenct macros now..
I wanted to have one macro for my purpose..pardon my ignorance please

Nasir


Hi Nasir .... I won't attempt a detailed tutorial of what and why behind
the code I offered; but I will try to answer any specific questions you
have.

Start with AB's (Thank you AB!) reply to your post - launch
ScanWorkbooks which will call the other procedures as needed.

These newsgroups are a good place to ask questions --- there are many
here who are happy to help others learn. All we ask in return is for you
to try and understand our suggestions; and to ask specific questions
when we leave you confused.

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)