Hi, I'm having a performance issue while running the following formula:
I'm only iterating over 150K rows, but the calculation times out and never seems to finish.
It works fine with 2K rows, but really starts...
I am using Excel 2013
In cell L11 I have this formula
This returns the address in the cell as $G$45 but the row number will change each time I loop the macro
In my code I want to go to that address and continue running the code.
to do this, I am using this code
I've been running the same macro-enabled spreadsheet almost daily for years...well, this one happens to grab NHL stats. I'm using Office 365.
Last night I had run a different spreadsheet using the fuzzyvlookup function that's been posted here for years, copying a formula down some 2500 rows...
I am trying to use a nested IF statement but I can't get it to work.
In cell H34 (running total for 2013 = 0):
Hi I'm trying to build a formula that has the running total by hour.
I use CUBE members
Here is the hourly cube:
This is the sales formula pointing to the hour above...
Hi, i'm trying to build a running total by hour.
I have a power pivot CUBE formula for the time:
And what i need is to see the total up to this hour. I'm pulling in last years values. If the hour is after...
I am running a few checks at the beginning of my macro to insure that the data is correct.
What am I doing wrong? I want to check that the sum of this range is lower than 10 before running the macro.
Set costrange = wks.Range("H8:H46")
Set costcheck =...
**Newbie VBA/Macro user*** - I use forums and Youtube to learn how to code but in there somewhere are probably some bad habits.
I have a form button on a project i'm working on which has now gone a bit slow to calculate.
The button picks a random number between 1 and 10 in the...
i have a macro which depending on data size, can take up to 2 minutes to complete.
Now ive found if whilst this is running the user gets impatient and clicks the mouse / keyboard etc.. then i get "excel not responding"
Is there any way to prevent this? Was thinking maybe a userform box...
Hi, I have sales by the hour. Each hour I have a cell with the total sales.
I'm looking for the best way to have running total, but if the time is after now it will display 0.
1pm $200 $200
2pm $150 $350
3pm $ 75 $425
But if the time is after now then dont give the hourly...
Hi guys need help with vba code for userform
Cells formated to date dd/mm/yyyy and use the isdate etc on userform....and if not a valid date wont accept....but noticed entering 07/12/18 will go into cell as 12/07/18...frustrating
Also managed to get update button to update data with addition of...
I have a UDF that does some iterative calculations. It can take anywhere from about 2 to 8-10 seconds to complete its work. The data, which I enter into an InputBox, comes from another application. If I hot-key over to the other application, the UDF stops running until I hot-key back.
Hi everyone I would like to ask a help regarding on Automation Error Exception Occurred. I have created an Excel application. Excep as a front end and Ms Access as a backend. Basically all the data that will input in the Excel userform will be exported to Ms Access. The application is running...
Before Running macro
The sheeet1 contains following data. I need number of days between 1-4-2014 40 31-3-2019 which should be displayed in shet2
I have a worksheet that I wish to enable protection on.
Unfortunately, whenever the worksheet is in a protected state and I update any values in any unlocked cells which the macro automatically applies sorting to, the following error appears:
Even if no cells have a "locked" attribute when I...
I have a macro running that seems to have run away and will not stop without control alt delete. Also ESC or CTRL-BREAK also don't work. IT's so weird. Sometime I will allow it to run over night and the next day it will be done and other times it will still be running. There is no rhyme or...
I have a complicated windowed running total I'm trying to calculate. I've made an excel example that I'd like to implement in powerquery so I don' thave to copy the formulas down. Here's an example file