Rows 1 thru 32 don't correspond to characters.
--
Gary''s Student
"Michael" wrote:
Hi Kevin. I tried your suggestion, but for some reason all I'm getting is a
little square on the left edge of each cell in column B. Any idea why?
--
Sincerely, Michael Colvin
"Kevin B" wrote:
Open the VB Editor (Alt + F11) click on Help, click on the Answer Wizard tab
in the Help dialog box and type in ANSI for a listing of ANSI characters.
You could also fill column A, starting at row 1, in a spreadsheet with the
numbers 1 through 256 and in column B enter the formula =CHAR(A1) and copy it
down to B256 to have a handy reference sheet.
--
Kevin Backmann
"aftamath" wrote:
Where can I find a complete list of all the character codes in VBA. eg.
Chr(10) is sn enter or new line. I like the list that VBA Help shows.