Plz suggest how to 91 valuesw.r.to columns

Closed
sashi - Feb 4, 2010 at 02:06 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 4, 2010 at 07:30 AM
Hello,


This needs a solution on top ptiority, see if some one can help, say if I have an array that can hold of 91 values like avarray(1 to 91) as variant/string, Please suggest me the code to paste this 91 values in different columns like A,B,c,d,e,....AA,AB,AC,.... till CM.

SUggest
Sashi

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 4, 2010 at 07:30 AM
see if it works for ya

startcol = 1
for each x in myarray
cells(1, startcol) = x
startcol = startcol +1
next
0