Increase column heading letters withing routine?
 

After each time my program cycles through a For routine, I want it to
increase the column heading letter so that the next time it cycles through, I
can have it input data in the next column. Is there a way to do this? Thank
you.

Increase column heading letters withing routine?
 

Selection.Offset(0,1).select

HTH
--
AP

"Adam" a écrit dans le message de
...
After each time my program cycles through a For routine, I want it to
increase the column heading letter so that the next time it cycles
through, I
can have it input data in the next column. Is there a way to do this?
Thank
you.

Increase column heading letters withing routine?
 

For i = 1 to lastNum
columnNum = i+4 'exampl starts at column E
Cells(1, columnNum_.value = "somevalue" 'E1, F1, etc.
Next i

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Adam" wrote in message
...
After each time my program cycles through a For routine, I want it to
increase the column heading letter so that the next time it cycles
through, I
can have it input data in the next column. Is there a way to do this?
Thank
you.