macro merged cell

[max_max]

Hello to all.
this macro does not work on merged cells, an aid to correct?

Please Login or Register  to view this content.

max_max

[TMS]

The cell count of a merged cell will be greater than 1 so, chances are, you'll fall at the first hurdle.

[max_max]

Hello
can it be corrected or must it be changed completely?
max_max

[max_max]

I modified:

Please Login or Register  to view this content.

if the cells are megerd, it does not cancel.
An aid to correct?
max_max

[max_max]

Hi, I corrected this way

Please Login or Register  to view this content.

An error if I manually delete the merged cells at this point:
If InStr(Target, Mid(Pattern, C, 1)) <> 0 Then 'se il carattere čat this point presente in Target
max_max

[TMS]

Try:

Please Login or Register  to view this content.

[max_max]

Hi TMS is perfect!
Thank you so much.
A greeting.
max_max

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.