Increments in Column

[uhayatpk]

Hello Sir(s), I am now in <acronym title="visual basic for applications">VBA</acronym> and I want some from your side in this code.

Dim Strg As String
Dim Z As String
Dim n, nn As Integer
Dim c As Integer
Dim Lst As Integer

For nn = 64 To 83
Lst = IIf(nn = 83, 88, 90)
For n = 65 To Lst
c = c + 1
Strg = IIf(nn = 64, vbNullString, Chr(nn))
Z = Strg & Chr
Next n
Next nn


Here in this code he is only go to SX I want this code run ZZZ. how it is possible within these command lines I need your help urgently.

 

[oldbrewer]

char(255) is the final value

for my education, what is IIf please ?

 

[uhayatpk]

oldbrewer Sir, I do not know. Any copy from any one site. It do work me but it go to SX charters but I want this go to ZZZ

 

[oldbrewer]

Strg = IIf(nn = 64, vbNullString, Chr(nn))

should it be

if nn=64 then STRG= vbnullstring else STRG= chr(nn)