View Single Post
  #2   Report Post  
Old November 27th 20, 02:03 AM posted to microsoft.public.excel.programming
NoodNutt[_2_] NoodNutt[_2_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2020
Posts: 39
Default Copy paste different size problem

Hi ytayt

xl2007 onward can cater for up to 16,384 columns.

https://support.microsoft.com/en-us/...AA=Office_2007

If you need 1500 Columns or more, chances are you will need to upgrade to a later version.

In the event you can't upgrade to a more modern version, it will be difficult to speculate on how to compress 1500 rows into 256 columns without knowing what your 1500 rows of data is.

There are many super-talented programmers here, if it can be done, they're likely to know, but! you need to ready for disappointment given the limitations of your Excel environment.

HTH
Mark.