Run-time error '1004: Cannot rename the sheet as another sheet as same name

Hi,
If I run this macro with the values in the column as 'A' and 'a' i am getting error.Basically code is differentiating upper and lower cases

Please Login or Register  to view this content.

Thanks,

VBA is case sensitive by default, so if the

code is differentiating upper and lower case

then add

Please Login or Register  to view this content.

to the General Declarations section at the top of the module/userform/class or whatever.

That makes all text comparisons non case sensitive.

Note the setting only affects the module it is defined in. You will have to add to each module as required.

You could also consider adding

Please Login or Register  to view this content.

to your .FIND statements.