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

Plz suggest how to 91 valuesw.r.to columns
Tweetdeck larger columns - Guide
How to delete columns in word - Guide
Display two columns in data validation list but return only one - Guide
Excel columns changed to numbers - Guide
Excel partial text match between two columns - Guide

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

Similar discussions

Macro to Select Multiple Columns by Columns Specific Headings to Delete Dupes

Excel Macro - Set and autofill a range?

Insert Line Number for Two Columns Document

range of numbers

Copy range data in a column to new column.

Similar discussions

Subscribe To Our Newsletter!