starttime

Hi guys- I am running this code on a document with ~ 25,000 rows by66 columns wide. This code right now is taking around 45 seconds to 55 seconds to run, and sometimes I get the (not responding) and it takes over a minute. I was wondering what steps in my code could be adjusted to run faster...

Hey community, I have following code / i wanna know how many seconds it takes this macro to run. Sub Brn() Dim Markets As Worksheet Set Markets = Sheets("sheet4") Sheets("DATA").Range("A:A").Name = "run" Sheets("DATA").Range("L:L").Name = "aris"...

Currently my code is basically as below but the finishing time pops up and the background queries are still running. I want them to run but I want the timer to consider them instead of ignoring them. Sub CalculateRunTime_Minutes() 'PURPOSE: Determine how many minutes it took for code to...

Hi all, I want to clear cell "I15" after 60 seconds. I will be calling this sub within another sub. Probably being stupid but can someone see why the following isn't working? The cell is being cleared instantly. Sub ClearTimer() Dim StartTime As Single StartTime = Timer Do While Timer -...

Hi , The below link helped me to workout a old problem i was facing of copying picture from website to excel. https://www.mrexcel.com/forum/excel-...namic+url+cell Need help again. The Code and modules which was given was very fast , it processed 500 entries in 20-25 seconds . i had another...

Hi, We have an SQL query that uses a stored procedure on our database. For some reason it keeps going into error every few days. I made the below to refresh the query and try to detect the time for the break, however, coming in this morning to check it, it has errored (msgbox displayed) after...

I am trying to check if a File Exists in a Directory and If it Does Not then I want create it Seems straightforward enough but I keep getting a "Bad FileName" error on the Open for Output command Simple code is : Dim CheckFile As String CheckFile = "C:\aaValidate.log"...

Hello everyone, Question regarding a macro I have, see pasted below. I have an excel file with approximately 100 sheets, and would like to automatically format rows and columns for specific sheets based on cell values in row 1 and column a. I have a tab named "List" which is named as...

I'm toying around with using arrays instead of working in ranges. Here is a simple array Sub dotest() Dim DirArray As Variant starttime = Timer DirArray = Range("c:t").Value For Each x In DirArray 'Debug.Print x Next MsgBox Round(Timer - starttime, 2) End Sub While I want to load the entire...

Hi, I found on internet a code that send a calendar entry meeting in Lotus Notes. The code works, but when I put more than one attendee, it send only to the first person in the cell. For instance, in image below on the B2 cell there is two e-mails: xx@nda.com and dd@nda.com separeted by...

Hello everyone, my first post here :) I am writing a VBA script to automate a task. I have a column which contains both date and time in the format of (yyyy/mm/dd h:mm:ss). I have to split the date and time and send it to an outlook method. I did the following: Dim startDateTime As String...

Hi there, I have a userform which displays a time in a textbox (StartTime), for example 11:15 I have a second input box which the user types in the number of minutes a task has taken (TimeTaken) - this is always in minutes (eg 6hrs = 360) And there is a third textbox (EndTime) which is...

Hi. I am exploring execution time overheads using various structures of code. I came across this today - an Overflow error (on the highlighted line) caused simply by declaring data type. Can anyone explain it please? When I run the code without declaring the arguments I am passing as...