Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

Extract identical cells of 2 columns (excel)
Little bit lost -
keliza -

3 responses
Comparing columns and returning value
ll -
kittu -

35 responses
Converting rows of data in notepad to columns
Need help -
Philgood_FR -

2 responses
formula if you have credit in one column, debit in next column
Jack -
Jackthelad -

4 responses
Increment cell value based on change in value of another cell
Sarah -
TrowaD -

1 response