PDA

View Full Version : Carriage Return not working



mzsuga
10-22-2009, 12:38 PM
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
10-22-2009, 12:49 PM
I haven't tested, but it looks like you need to add some " marks before and after the & signs:
cStay = Array("Nae", "List Name", "Base Cost" & Chr(10) & "(per thousand)")

mzsuga
10-22-2009, 12:52 PM
I haven't tested, but it looks like you need to add some " marks before and after the & signs:
cStay = Array("Nae", "List Name", "Base Cost" & Chr(10) & "(per thousand)")

that worked, thank you!