Windows 10 Excel pro Plus 2019 I am getting a Run-Time: error 13 - Data Mismatch when running my code below with excel VBA editor highlighting the two rows Code: If arrData(i, 1) = arrData(i + 1, 1) And arrData(i, 2) = arrData(i + 1, 2) And _     arrData(i, 9) = arrData(i + 1, 9) And arrData(i, 10) = arrData(i + 1, 10) Then I wanted to achieve the fastest possible method using VBA as using a formula (which I explain further down) takes excel over 6 minutes to run on a spreadsheet with currently 91,000 rows and when live, this figure will only increase. What is it I am running the ..read more

I have written a code that makes the table almost, the only problem with it is that whenever there is a margin call or margin release, the deposit doesn't change by the value of the margin call/release (margin call needs to be added to the deposit, margin release needs to be taken away). I can't move forward; I need to simulate 1000 times the profit rate for every liquidity buffer (0%-100%) and make the liquidity profit rate table Attached Files problem.xlsm (256.8 KB ..read more

Just a quick question. Is it possible to chart hidden data ..read more

Hello everyone. I am using Windows 10 and Excel 2019. This is my first post here and I hope to learn and maybe, in time, give back. I use the code below to. 1. Clear all cell contents and formatting 2. Adds the text (value?) for cells A1 to AI 3. Fomats the cells 4. Freezes the top row. It seems to be a lot of code to do what appears to be something simple. My question is, is there a more simple or efficient way of writing the VBA code? Many thanks Code: Sub TestAddHeader()     With Application         .ScreenUpdating = False         ..read more

I am new at this forum :hi ..read more

Hello! Im quite new to using VBA in excel and while trying to make a macro to one of my workbook, ive encountered an error i cant figure out how to get past. I've taken inspiration from Excelforfreelancers inventory management system, and modified the code to fit my needs, but it returns with an compile error: Invalid or unqualified reference, highlighting the issue to be "Sub Menu_select" I confess i dont 100% understand the scope of this function, as every macro i use is more or less just recorded with the exception of a few, so this has left me a little confused. Any help/explanation of ..read more

I need a function (F) that calculates the table I uploaded based on the data. After that, you need a function (G) which calculates, given a given liquidity buffer, which one on which day the investor exits the deal, and what is his profit. This function has 2 inputs there are: the table created with the previous function and the size of the liquidity buffer. The function should check which is the first day on which the liquidity buffer and is the amount of the initial deposit is less in absolute value than the accumulated cash flow (last part of the table). column). If this day is t. day, then ..read more

I have a general question on accessing recordsets My VBA creates a recordset in module1. I purposefully did not close the connection or the recordset. I would like to be able to re-use the recordset in a couple of different modules (say 2 and 3). Is this even possible? Im looking for any sites, literature, etc that can help. Any direction you can give is greatly appreciated. Thanks in advance. -Chunk ..read more

I have a Word document (attached) where the user is to enter information about the status of several tasks. For each task the user is to select the status of the task from a content control dropdown list. Options are: "No issues" or "Issues found". If "Issues found" is selected, the user is to provide a description of the issue for that task in a textbox. While the code works for the first task, it does not work for the content controls in the second task What am I doing wrong? Code: Private Sub Document_ContentControlOnExit(ByVal CCtrl As ContentControl, Cancel As Boolean)   If CCtrl ..read more

Hello! I know this question may seem a bit silly, but I'm starting in the world of VBA and I don't know many things, I saw that this forum was active and that's why I ask here :) I'm doing something similar to a Game Show, where on slide 1 they ask for the name of the contestants and I wanted the Shapes of all the slides to show the given name. I saw that many people said that I could do a For cycle and go through all the slides changing the Shapes texts one by one, but it's not efficient when you have more than 100 questions ;-; Is there any way to make the text of all Shapes always be ..read more