Transpose exceeds 65k

[cpvrajan]

Hi,

I have a program where i retrieve few files content and copy it to excel for reportig function.
But as i try to consolidate most of the time the range exceed 65000 and therefore fails - can you kindly help me to resolve this.

Pls see my code below:

Please Login or Register  to view this content.

[FDibbins]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I will add then for you - this time

[Marc L]

Hi,

TRANSPOSE function is limited to 65k ! Over this limit, you shoud use your own function …

[romperstomper]

Here is one such function: http://excelmatters.com/?p=27

Code inline for ease of use:

Please Login or Register  to view this content.

[cpvrajan]

Thanks a lot romperstomper - It resolved the issue

Thanks FDibbins, I will do that in my future posts!

[mc84excel]

Hi,

TRANSPOSE function is limited to 65k ! Over this limit, you shoud use your own function …

I agree.

I use the Transpose function by Alan Beban. See post #5 http://www.excelforum.com/excel-prog...transpose.html