Minggu, 01 Januari 2012

[ExcelVBA] How much text data?

 

*How much text data can Excel hold in one sheet? Anyone know?

For an experiment, I tried to fill a sheet with a complicated formulas in
limits, and it would not do it. (Wow- 65536 * 256 cells of formulas!!! No
wonder that wouldn't work.)

Could I fill nine columns, from top to bottom, of text information and it
not fail? Anyway to test that before I actually try it? Only the first
three columns would be sorted, from low to high. Or is that too much for
Excel to handle. This is Excel 2000, Windows XP, two gig of memory, and two
terabyte hard drive.

**Thank you.

**Robert*
*Genealogy without documentation is mythology! Always SOURCE your work.*

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar