MsgBox "Letter " & Chr(64 + i) & " is column # " & i End If

Loop End Sub

If you don't think that memorizing column numbers sounds like fun, or even if you have to figure out the column number of Column DG someday, there is a fairly easy way that uses the Excel interface. Move the cell pointer to Cell A1. Hold down the Shift key and start pressing the right arrow key. For the first screen of columns, the column number appears in the name box to the left of the formula bar (see Figure 6.10).

Figure 6.10

While you select cells with the keyboard, the Name box displays how many columns are selected for the first screen full of columns.

□ Micro soil Excel - Chapler6.xls

:>§) Els Edit sew Insert Format


Qato ^idow tlelp

; J 3 A _J J jj. j -


z - zi I ÊJ1 .fig_Hi»"1'

I 1Rx6C - f, I

0 0

Post a comment