Macro Help !!!!

[GazMo]

Thanks for your help, howver ... It falls over at :

If LCase(sh.Name) <> LCase(sh1) Then

saying "object doesnt support this property or method"

????????

 

[Dave Peterson]

If LCase(sh.Name) <> LCase(sh1.Name) Then

Thanks for your help, howver ... It falls over at :

If LCase(sh.Name) <> LCase(sh1) Then

saying "object doesnt support this property or method"

????????

 

[Tom Ogilvy]

That was one of those ill advised last minute changes

As Dave advised, add name to the end of Sh1

If LCase(sh.Name) <> LCase(sh1.Name) Then