memory

I have a spreadsheet with a fairly complex userform that acts as a UI. I believe the issue is caused by the ammount of controls i have on my userform as it was working fine upto a point. I have already upgraded from 32 bit excel to 64 which solved the issue at an earlier stage when i had less...

Maybe a silly topic, but I'm still novice and quite unsure about some details. I have a Userform. Left side column has the menu, consisting of 7 options/"buttons". Those buttons are actually images which change when their area is hovered. E.g. they are originally blue, the hovered state is...

I'm getting this problem "OUT OF MEMORY", when I run my vba. My vba basically takes various things from a online csv which grabs time, year, # of ad clicks, weather, and, it takes it from there and pastes it into my document every 5 seconds or so. So I have an up-to-date dashboard of...

I have a problem with a new laptop, whereby when I try to paste a filtered sheet into another sheet, which is something I do all the time and is a big part of my workflow. My system is an i7 9th Gen with 32 Gig of Ram and brand new and I have more than 20 gig of memory free when I encounter...

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...

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...

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)...

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...

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

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...

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...

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...

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...

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?

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>...

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"...

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...

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...

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

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...