Hiya,

I want to convert a number to it's character value within a VB variable in
Excel - this can be done using CHAR() within the worksheet - eg CHAR(66)
results in "B".

CHAR() doesn't seem to work in VB - does anyone know how I can do it? I need
it to populate a variable using an integer, i, which I increase by 1 in each
iteration of a loop.

Thanks!

Basil