How to store cell value in a variable excel vba OR Increase Cell Value in Excel

Solved/Closed
Raj_1562 Posts 31 Registration date Wednesday August 26, 2020 Status Member Last seen August 29, 2022 - Apr 23, 2021 at 09:25 AM
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 - Apr 24, 2021 at 06:57 AM
Dear All,


Excel is only able to store 32767 characters in one cell. But I retrieve the more than 50000 characters.So, I couldn't able to store in the cell. So, I wish to store the value to a variable in Excel vba. Is it possible to store the value of the variable in excel vba? How to store the value in a variable? Or Is there any option to Increase the cell value more than 50000 Char in excel?

Thanks in advance,

Regards,
Raj

1 reply

vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 252
Updated on Apr 24, 2021 at 07:12 AM
Hello Raj,

The overall answer to your query is "No".

Excel is not meant to be used as a database (more for calculations than anything else) and I would suspect that you are importing data from some external source into Excel. The cell limit of 32,767 characters is by design and is "not negotiable". There are work-arounds but these could do more harm than good and would be difficult to use and the time spent on trying work-arounds would be better spent on setting up/using actual database applications such as Access.
Consider that Excel holds in excess of 17 billion cells and then consider there are 30,000plus characters per cell, then consider the size of your workbook.

You'll find Excel specifications and limits here:-

https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3

You should seriously consider a more suitable database application.

I hope that this helps.

Cheerio,
vcoolio.
1