You cant, 65536 is written in stone. Regards, Alan.
B bj Aug 16, 2005 #4 actually for columns 256, but you can go to new worksheets with an additional 256 per sheet.
S StinkeyPete Aug 16, 2005 #5 65,536 rows by 256 columns (maximum limits) see Excel specifications and limits in the help file
A Alan Aug 16, 2005 #6 Jees!, Done it again JE! Must read more carefully! Ever felt a fool? lol Regards, Alan.