Maxmium Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear Sir

Is Excel has maxmium columns size limited to "IV"? How can I add more columns over "IV" in one sheet?
 
Afraid there's nothing you can do to enlarge the WS.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Dear Sir,

Is Excel has maxmium columns size limited to "IV"? How can I add more
columns over "IV" in one sheet?
 
It may not be a wise decision to use ALL the columns in
the sheet. Break it up into types of info and share it
among new sheets. Your one sheet may be over 10mb and it
maybe unopenable one day. I am not sure how "heavy" a
single sheet can get but if you have many formulas, it
will be very heavy!

You can have a userform to "pull" info out of the new
sheets. This required info can then be displayed as needed
for printing or whatever. Another userform would be wise
to insert your data. This data can be written to the sheet
by way of a macro from the text box to the sheet.

Try out listboxviewer.xls at :
http:\\au.geocities.com/excelamrksway
It won't do what you want but I can write one for you for
free.

with regards

Mark E. Philpot

PS you can send a dummy worksheet, about 5 lines, and what
you really do, so I can review what is required.

(e-mail address removed)

-----Original Message-----
Dear Sir,

Is Excel has maxmium columns size limited to "IV"? How
can I add more columns over "IV" in one sheet?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top