memory

  1. mikerickson

    New computer, new Office

    Hi folks, I bought myself a new Mac Book. My old Office 2011 is out of installs and it looks like Office 2019 is where I'm going. But I do have a couple of questions. Does anyone who has experience with 2019 know if: 1) does it support VBA (in memory of 2008 :) ) 2) is the MacScript command...
  2. J

    Setting Userform textbox value from Worksheet_Change

    Hi, The following works fine (I'm currently using Userform1 with vbModeless) Userform1.Textbox1.Value = Target I just want to know what affect this has when the Userform hasn't been loaded. It seems nothing happens but is it using memory? Or a bad idea? Can I check whether the Userform is...
  3. S

    Maximum Size for a 2 dimensional array

    Hi - Been a while, but I'm hoping to find a way to fix a limitation on a reconciliation tool I designed a while back to compare two extracts from an SQL database. In particular I'm having trouble on memory limitations when Resizing a Variant array: ReDim Ukey(1 To MyDict.Count, 1 To ((H - 1)...
  4. L

    Keeping array values after macro run

    Hey guys, I have a project that I'm making and it contains 3 arrays. Once i run the macro, all the actions are done, but the array is not erased, if i re-run the macro the values inside keep doubling(keeps old values and adds them again). I am using erase at the end of the last sub now to make...
  5. C

    How to Obtain "Available Memory" Number with VBA?

    Is there a way to obtain/calculate (or approximate) the "Available Memory" Number shown in Task Manager using VBA? Thanks.
  6. B

    Make worksheet run more efficient?

    Hi, I use a worksheet that is mostly pics of several hundred small charts and lines with text descriptions of each. It is currently using about 460MB of memory, but the pics will increase as time goes by with updates. Are there any "tricks" I can use to help it run more efficient and use less...
  7. L

    Question about memory usage in excel

    I have a grade book for a school. It is shared online for teachers and staff to use/edit. Due to the number of formulas it can get kind of bogged down. So I am looking to save some processing power and accomplish the same task. A teacher enters a percent in cell then the cell below has a...
  8. L

    Excel Out of Memory on Closing

    Hi guys, I have a workbook that uses large sets of data ~8000rows and counting, and whenever I close this work book, Excel gives me the "Out of Memory" pop-up, once I click okay it pops up again, and again... The only way to fix it is to close all my workbooks. > I have Formulas that use...
  9. P

    "Out of Memory" when I try to run a web query

    I have a brand new Acer Aspire E 15 Laptop (purchased August 3, 2018 ... 8th Gen Intel Core 13-8130U, 6GB RAM Memory, etc.). The only thing I use the computer for is to surf the Internet and work on a college football spreadsheet. Specifically I run web query(s) in Excel to bring box scores...
  10. J

    Out of Memory when loading huge range into an array

    I am comparing the used range on every worksheet on two workbooks to find cells that were changed. Some of these worksheets have a massive range: A$1:$CD$1048575 When I try to load this into an array, I get and Out of Memory error. Is there anyway around this?
  11. A

    vba to show images in comment box causing Out of Memory

    Hi, I have some VBA to take a path from the 2nd column and show an image for the cell that has been clicked using the comment box to display the image It looks great, hopefully others can use it if this error gets cleared up Example sheet <tbody> <tbody> <tbody> ML053 </tbody>...
  12. P

    How to clear excel memory

    I am using Excel 2016 as a means to capture data from a piece of equipment that has a web IP address/USB port. If I use a web browser, the URL would be http://127.0.0.1:44789/evox/bacnet/2/0/51/117 and would get back a response <int< font=""> xmlns:trane="</int<>trane:evox"...
  13. C

    UserForm Level Variables Scope Question

    I have several variables declared at the top of my UserForm (outside of any procedure), some of them are ranges, ListObjects, and PivotTables. Is it necessary to use Set variable = nothing before closing the UserForm to remove them from memory, or will they automatically go out of scope when...
  14. V

    Insufficient memory when closing unnecessary workbook!?

    Hey guys, I'm getting an inexplicable memory error while trying to optimize my code. My macro is pretty big and totally not optimized, but it shouldn't be exceeding the limits of this computer quite yet. Even stranger so: the error only occurs when trying to close an unnecessary workbook...
  15. E

    Clear Memory Cache

    Hi, I have a workbook with lots of code and formulas, one of which copies data from another workbook, which used to work quite quick, but is now painfully slow Is there a code to clear the cached memory that I can call against my different codes to copy data? many thanks for any help
  16. H

    Out of Memory Error

    I am getting an out of memory error when after closing the workbook in the following code. I have an Add-in that opens another workbook and runs other code which opens a form and allows the user to interact. When the form is closed the workbook closes and doesn't save per the code below. As...
  17. H

    Out of Memory....caused by "Save"!?!?

    Hi all, I have an unusual VBA Out of Memory Error. I have a spreadsheet which I have restored from backup, which opens fine, behaves fine, and does all it should (it contains about 10 modules, none of which is bigger than 64kb). It contains a couple of very small forms. It also contains about...
  18. H

    Weird VBA problems. Out of memory. F8 step through failing. crashing...

    Hi guys. I did google this, at length, and found the answers not that helpful. Just FYI. ;) I have a vba module thats about 28 pages long. There are 5 of these modules. Each module has around 100 declared variables. I need to add more. About 10 more to each. When I try to add more using...
  19. A

    PC requirement for Excel to run Properly

    Hi, I have an excel database worksheet and occupied 65,000 rows and 15 columns.Column A had this formula (=IF(COUNTIF(B:B,B7)>1, "Duplicate!","Not Duplicate")), Column B had this forumula (=CONCATENATE(SUBSTITUTE(SUBSTITUTE(C2,",",".")," ",""),D2,SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G2,",",""),"...
  20. L

    number of rows and columns and computer memory

    Hi each sheet in excel 2010 has 1M rows and 16K rows. If I open a sheet, are all columns and rows are open (saved in computer memory)? or excel opens few only and it will open more as we screw down. What i mean by open, is to create or reserve line in the memory of the computer. because 16B...

Some videos you may like

This Week's Hot Topics

Top