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...
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...
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 =...
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
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...
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...
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
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...
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...
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...
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...
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]...
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...
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...
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 &...
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...
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...
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...
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...
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 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.