View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ten Ten is offline
external usenet poster
 
Posts: 9
Default Next Charachter

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()



.