Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
More than 256 columns in an Excel worksheet
11 views
Skip to first unread message
Pascal Denis
Dec 22, 1998, 3:00:00 AM12/22/98
to
Will it be possible to have or use more than 256 columns in an Excel
worksheet, specially using VBA. (As example Data acquistion with 400
ways ..)??
worksheet, specially using VBA. (As example Data acquistion with 400
ways ..)??
many thanks
Patrick Molloy
Dec 22, 1998, 3:00:00 AM12/22/98
to
an often asked question, but the answer is no. I generally recommend
transposing the array as there's 31000+ rows although the MVP's seem to get
a bit annoyed with this. However, my view is that if the answer is negative,
offering alternatives my provide insight to a solution.
good luck.
transposing the array as there's 31000+ rows although the MVP's seem to get
a bit annoyed with this. However, my view is that if the answer is negative,
offering alternatives my provide insight to a solution.
good luck.
Patrick
_____________________________________
Pascal Denis wrote in message <367FB22F...@esim.imt-mrs.fr>...
Paul Felce - MVP Excel -
Dec 22, 1998, 3:00:00 AM12/22/98
to
I've no problem with transposing the data 8-)
However , you may want to
1) Spread your data over several sheets
2) Consider writing your data out to a database.
You haven't said what you want to do with this data, so it's hard to
evaluate the alternatives.
--
Paul Felce
- MVP Excel -
"You'll Never Walk Alone"
Patrick Molloy wrote in message <75oehp$qe4$1...@news.ml.com>...
Rraywilson
Dec 22, 1998, 3:00:00 AM12/22/98
to
I am familiar with data acquisition using Excel. If you want to give out some
details, I might have some further pointers for you.
details, I might have some further pointers for you.
Ray Wilson
0 new messages