View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jack Sons Jack Sons is offline
external usenet poster
 
Posts: 144
Default simple code with "abc" & "*"

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