speed

  1. P

    Cycling Speed Calculator

    Morning all. I am trying to create a cycling calculator in excel for average speed. On this site, there is the "Average Speed Calculator, how can I recreate it in excel? I know the distance in miles ex. 100 and time 04:39:02.50 (hh:mm:ss.ms) looking for the average speed. Thanks...
  2. K

    Asynchronous Function Calls

    Greetings, I'm in a bit of a dilemma and hope that someone can help For reference, the module I am using can be found here: https://github.com/VBA-tools/VBA-Web I need to develop an excel add-in that plugs some data from a cell into a function, sends that data to the backend of a web...
  3. P

    IF/Then statement not working

    For some reason the if statement in the code below isn't picking up when it should. I can see that on step 69 it should pick up but it's not seeing 3 = 3 as true. I think it's something to do with the Data array. Sub XYZ() Dim i As Long Dim Speed as double Data =...
  4. S

    Formula speed in excel?

    HELLO ALL HOW I CAN CHANGE SPEED VALUE FROM KILOMETRE IN HOUR TO MITRE IN MUNITE IN EXCEL. ANY FORMULAS TO FIX IT https://1drv.ms/u/s!As8Mdv-a95REhTVTGRT4Nc4oM2Uq
  5. H

    speed up Macro to Delete Blank Rows

    I have a macro to delete blank rows in Col M I have +- 100,000 rows of data so it is fairly slow Sub Del_Blank_Rows_ColM() Sheets(2).Select Application.ScreenUpdating = False Columns("M:M").SpecialCells(xlCellTypeBlanks).EntireRow.Delete Application.ScreenUpdating = True End Sub It...
  6. N

    Formula speed checking

    I have a fairly complex workbook and it got to the point that doing certain things become very slow. I would like to optimize the responsiveness of the workbook. I think I tried as many ways to improve as I know. That including replacing all volatile functions, using dynamic ranges, removing...
  7. T

    Looping for speed

    I read that purely for speed purposes, you should use a For Each loop when looping through a collection. For arrays, use a For Next loop. What about for a dictionary? Which is faster? Thanks
  8. B

    VBA Runtime Differences

    I have written a VBA that will group items in a worksheet if certain criteria are met and collapse those groups. I have assigned a form button to run this macro so it was easier to test in different situations to make sure it would always work - and everything is going great with the actual...
  9. How_Do_I

    Average Speed / Average Speed IF

    I'm having trouble with these if anyone could help please. I think the format of my time hh.mm.ss isn't helping me. I'm after the average speed in D2 downwards and the average speed for week number 4 in F4 please. Excel WorkbookABCDEF1WeekDistanceTimeAverage232.6400:49:29Week...
  10. M

    Is there a faster substitute for SUMPRODUCT formula?

    Hi, is there a faster substitute for SUMPRODUCT formula? Went through some forums etc. and found only that SUMIF could be a substitute. But I can't get it work for me, I guess probably because I have 'transpose' in 'sumproduct'. The formula I want to speed up...
  11. TinaP

    Speed up workbook with many SUMPRODUCT formulas

    Hello All! I have a massive workbook with thousands of records. For each record, I need to include three weighted averages. I am using SUMPRODUCT to calculate the weighted average. Every time a change is made to the workbook, it takes about a minute to calculate, which gets old very quickly. Is...
  12. K

    SpinButton To Change a Variable in a Running Macro ? / MS Word

    Is there a way increase or decrease a variable in a running macro on a userform with a spinbutton on a userform. e.g. the value of X which controls the speed of a macro . . . Private Sub CommandButton1_Click () For Each w In Selection.Words w.Font.bold = True For i = 1 To X [default X = 1000]...
  13. J

    Excel Calculate field within pivot

    Sir/Madam, I have been racking my brains to try solve this issue. Basically I have a table of data which I need to perform a calculation on. It is a summary calculation for the day based on 4 or 5 different entries that day. This is an excerpt from my table. Date Available...
  14. C

    Speed up macro object_ Change()

    Hi, I have a "search box" where you can search for a name in my table named "manager1" and it will filter through. The problem is, it takes ages to filter as my table is 20X700 so it has lots of entries. Can we add criteria to the code where it will take effect only if user types 5 or more...
  15. S

    Maximum and Minimum Values

    Hi Guys , I have a table with three columns First contain date .. it take a form like (1/31/2018) Second contain time .. it take a form like (0:00:00) Third contain a variable speed that recorded for a mobile body Now , I kindly ask your help to find a way for extracting the maximum &...
  16. W

    Speed up Copy/Paste with variable range size

    I need to speed up my code. This code is looped through hundreds of times and is super slow. The problem is that the range of cells I need to copy and paste changes. Here is my original code: Worksheets(Sht2).Activate Worksheets(Sht2).Range(Cells(13, 1), Cells(LastPt, 15)).Copy...
  17. P

    Rid myself of .Select Selection

    I don't get why this is not working, but I am trying to clean up and speed up my code. I currently have this and it works fine within my sub. Columns("O:Q").Select Selection.ColumnWidth = 35.01 Columns("A").Select Selection.ColumnWidth = 6.01 Columns("B").Select...
  18. R

    Copying answers from previous calculation

    Hello, I'm trying to add a VBA code into a tool I'm creating for my thesis since the calculation is a repeatable calculation, although a lot of work to do by hand. Perhaps one of you guys is able to help me out on this. In my main worksheet "Resistance", I added a form control button where...
  19. G

    Excel 3D Maps - Speedometer or similar funcationality

    I'm brand new to 3D Maps in Excel, but have found them to be quite useful, though limited. I have Lat/Lon coordinates over time, but I also want to include some sort of Speed overlay that would show up when I use Create Video. (I have the Data Cards showing the data I am looking for, but that...
  20. J

    Making a Row Delete Macro run better

    Hello Everyone, I should start by saying I've only a very basic grasp of VBA. Some of the guys on this forum have helped me with some VBA code to delete unwanted rows of data from a spreadsheet, which does exactly what it should so thanks for that. Only thing is that i've run it with the same...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top