Looping through the alphabet

[aharris2693]

Is there a VBA function for moving to the next letter in the alphabet? My loop is based on an integer, and I have considered using a select case to read each letter and change it to the next one. I only have 43 columns, so I could do this, but if there is a simpler way it would be great. Thanks

 

[SkipVought]

Hi

The ASCII value for characters are published in Help.

But basically Chr(65) is "A"



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[aharris2693]

Thanks Skip
As soon as I posted this I remembered how to do it. A small brain lapse I guess. Thanks again.

 

[Zathras]

It sounds like you don't really need to get the next letter of the alphabet. It sounds like what you want is to get the next column in a worksheet.

I would recommend that you take this opportunity to begin to understand how to work with ranges as objects. It will stand you in good stead with future VBA coding issues. Study this sample code and see what you can learn:
[blue]

Option Explicit

Sub Demo()
Dim col As Range
Dim i As Integer
  Set col = Range("A1").EntireColumn
  For i = 1 To 4
    DoSomethingWithAColumn col
    Set col = col.Offset(0, 1)
  Next i
  Set col = Nothing
End Sub

Sub DoSomethingWithAColumn(AColumn As Range)
   MsgBox AColumn.Address
End Sub

[/color]