Looping Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can you return the next letter in a sequence

Ie

txt = a+
would equal b, then c then d etc..
 
Assuming the current letter is derived from the active
cell:

Sub NextLetter()
Dim txt As String
txt = ActiveCell.Text
txt = Chr(Asc(txt) + 1)
MsgBox txt
End Sub

Regards,
Greg
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining Text based on Values 8
Filtering using critera 7
Loop Through Text and Test for Scenarios Q 31
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Counting Criteria Values with For Loop 3
Date subtraction 1
Excel Convert word into numbers and back 4
Macro storing as a date? 11

Back
Top