vba - Loop through columns names : For variable = A to Z -


is possible loop on column letters?

for col = z    column(col:col).select    selection.copy next 

or oblige use function transform letters numbers?

to convert formulas values:

dim cols range, c string set cols = usedrange.columns  each c in split("n q t")   ' add rest of column letters     cols(c).value = cols(c).value ' or .value2 if no dates or currencies in range next 

if every third column column n, approach can be:

dim col range, long set col = usedrange.columns("n")  = 1 17            ' repeat 17 times     col.value = col.value     set col = col.offset(, 3) next 

Comments

Popular posts from this blog

account - Script error login visual studio DefaultLogin_PCore.js -

xcode - CocoaPod Storyboard error: -