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.
[email protected]
-----Original Message-----
Dear Sir,
Is Excel has maxmium columns size limited to "IV"? How
can I add more columns over "IV" in one sheet?
