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 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Apr 24, 2021 at 06:57 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Apr 24, 2021 at 06:57 AM
Related:
- Excel vba read cell value into variable
- Illustrator could partially read this file ✓ - Office Software Forum
- Number to words in excel without vba - Guide
- Ps3 won't read disc - Guide
- Read news on kindle - Guide
- Enable vba in excel - Guide
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
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.