How to store cell value in a variable excel vba OR Increase Cell Value in Excel
Solved/Closed
Raj_1562
Posts
29
Registration date
Wednesday August 26, 2020
Status
Member
Last seen
August 29, 2022
-
Apr 23, 2021 at 09:25 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Apr 24, 2021 at 06:57 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Apr 24, 2021 at 06:57 AM
Related:
- Excel vba cell value
- Number to words in excel formula without vba - Guide
- Vba case like - Guide
- How to open vba in excel mac - Guide
- Excel vba check if value exists in list - Guide
- Excel marksheet - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Updated on Apr 24, 2021 at 07:12 AM
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.
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.
