why not using

=CHAR(CODE("k")+2) - 'm'


Guido

HoloGuides
http://hologuides.com/programming/ExcelVBA


"Ten" schrieb im Newsbeitrag
...
Hi,
this properbly is a really simple one, but I can't seem to
work it out.

I have a variable with a charachter, say "k". Then I want
to get the Next (or Second Next etc) charachter to this
one, that will be "l" (or "m" etc), and save this into an
other variable.

I thgought about something like, but obviously dosen't
work:
Dim c1
c1 = "k"
Dim c2
c2 = c1.Next()

Thanks,however, had to try
= Chr((Asc("k") + 1))

-----Original Message-----
why not using

=CHAR(CODE("k")+2) - 'm'


Guido

HoloGuides
http://hologuides.com/programming/ExcelVBA


"Ten" schrieb im Newsbeitrag
...
Hi,
this properbly is a really simple one, but I can't seem
to
work it out.

I have a variable with a charachter, say "k". Then I
want
to get the Next (or Second Next etc) charachter to this
one, that will be "l" (or "m" etc), and save this into
an
other variable.

I thgought about something like, but obviously dosen't
work:
Dim c1
c1 = "k"
Dim c2
c2 = c1.Next()


.