"Nasir" wrote in message
...
On Mar 8, 3:42 am, "Clif McIrvin" wrote:
"Nasir" wrote in message
[ ]

Hi Clif
Thanks for your help
I changed the lines as per your instructions.

When I run the Private Sub ScanWorkbooks
I get Runtime error 1004 in Sub FormatWorksheet
“Select method of Range class failed”
sh.Range("A2").Select <<< this line is highlighted

Can you guide me please?

Hi Nasir

You're welcome.

I did some testing .... Range.Select and Range.Activate do not work
unless the sheet is the active sheet .... so change that one line to
these two lines:

sh.Activate
sh.Range("A2").Activate

--
Clif McIrvin

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