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

Report
Posts
27
Registration date
Wednesday August 26, 2020
Status
Member
Last seen
May 5, 2021
-
Posts
1292
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 7, 2021
-
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

Posts
1292
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 7, 2021
229
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
Thank you

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!