Plz suggest how to 91 valuesw.r.to columns

Closed
sashi - Feb 4, 2010 at 02:06 AM
rizvisa1
Posts
4479
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 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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