J
Jack Sons
Hi al,
I have this line of code:
If Range(Cells(commentrij, 43), Cells(commentrij, 43)).Text = "abc"
& "*" Then
The cell contains abc followed by some other characters (depending on the
row) but this line will not work.
If I use the complete text of the content of the cell, e.g. "abcdef", the
line of code works properly.
I guess "abc" & "*" is incorrect, but I don't know why.
What shoud it be?
Thanks in advance for your help.
Jack Sons
The Netherlands
I have this line of code:
If Range(Cells(commentrij, 43), Cells(commentrij, 43)).Text = "abc"
& "*" Then
The cell contains abc followed by some other characters (depending on the
row) but this line will not work.
If I use the complete text of the content of the cell, e.g. "abcdef", the
line of code works properly.
I guess "abc" & "*" is incorrect, but I don't know why.
What shoud it be?
Thanks in advance for your help.
Jack Sons
The Netherlands