Carriage Return not working

[mzsuga]

I have a cell that looks like this:

Base Cost
(per thousand)

It looks exactly like that so if you check the formula bar, it will be on 2 differnet lines.

So in my macro, i am search for that cell but it's not working. I have it as:

cStay = Array("Nae", "List Name", "Base Cost&Chr(10)&(per thousand)")

Please help

[TrippyTom]

I haven't tested, but it looks like you need to add some " marks before and after the & signs:
[VBA]cStay = Array("Nae", "List Name", "Base Cost" & Chr(10) & "(per thousand)")[/VBA]

[mzsuga]

I haven't tested, but it looks like you need to add some " marks before and after the & signs:
[vba]cStay = Array("Nae", "List Name", "Base Cost" & Chr(10) & "(per thousand)")[/vba]

that worked, thank you!