Hi all

How can I identify the character code for a square box into the
following line of code?

Range("D3:D" & LastRow).value = "=IF(LEN(A3)=0,IF(LEFT(A4,1)="","Keep
as divider","DELETE"),IF(LEFT(A3,10)="principal:","St art of
message","Contains info"))"

Currently this line results in the VBE error "invalid character" & I am
hoping to incorporate it into the string by using something like its
character code. Is this possible?

background info:
This is part of a larger collection of macros that work together to
allow me to filter & search historical emails (in a text file) after my
company swaps from Lotus Notes to Outlook. I hope to be able to provide
this to work colleagues for their use as well.
Column A contains the text from the messages & the character visually
represented by the square box appears to be the divider between email
trails & so I have offset it by one row eg "A4" cf "A3".

This box would not copy into a formula, but was able to copy it into a
cell & build the formula around it.

Any suggestions are greatly appreciated,

Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=530477