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
Thanks,Please Login or Register to view this content.
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
Thanks,Please Login or Register to view this content.
Last edited by narendrabr; 02-03-2014 at 11:27 AM.
VBA is case sensitive by default, so if thethen addcode is differentiating upper and lower caseto the General Declarations section at the top of the module/userform/class or whatever.Please Login or Register to view this content.
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 addingto your .FIND statements.Please Login or Register to view this content.
Last edited by cytop; 02-03-2014 at 11:44 AM.
can you please modify the code?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks