All Questions
Tagged with time-limit-exceeded vba
24
questions
2
votes
1
answer
117
views
Reviews a daily fantasy slate to check for duplicate lineups
My code below is used as a back testing tool to review a past Daily Fantasy Sports slate. This code works perfectly but when the contest size (total entrants) gets up to the 30,000 range it takes ...
0
votes
1
answer
63
views
Code compares Columns "A" of two workbooks and copies different information to destination workbook with entire selected row. LastRow count slows code
Code explanation:
I have a code, which performs two tasks -
To open two workbooks, one being extract info and one destination and it compares the column A with Column A of these workbooks and all ...
2
votes
0
answers
409
views
How to speed up the VBA scraping process
I want to scrape 25000 addresses using Column A cell values as search strings. I'm using the following code, it is working fine but it's too slow to extract 25000 results. Is there any way to speed up ...
0
votes
1
answer
5k
views
VBA Excel Looping through recordset and storing the data to use later
I have a loop to add Recordset items to a Dictionary so I can do comparisons and retrieve specific data later in the code (not ...
1
vote
1
answer
93
views
Merging records from one spreadsheet into another
I have created the code below that compare two spreadsheets . It initially compares the range of value from sheet1 ("Status") to sheet2 ("Interface") . Whenever a range matches with the ranges present ...
2
votes
3
answers
963
views
Looking for all numbers where each digit is bigger than the previous digit
This is the "Increasing Number problem", where we are looking for all numbers with \$n\$ digits where each digit is bigger than the digit before it. Or in Mathematical therms where:
$$\mathit{...
1
vote
1
answer
103
views
User form that searches a spreadsheet
I have this userform that looks up into a sheet. The problem is that when there are a lot of rows to look up it takes too long to execute (for example 100 thousand rows). Is it possible to reduce the ...
0
votes
1
answer
52
views
Macro to clear cells that do not appear in a master list
The macro below clears cells that do not match any cell in comparison to a range (a master list). It works on small file but is too slow to work for files with large ranges.
...
0
votes
3
answers
173
views
Writing many cells to sheet causes Excel to not respond, replacing vlookups [closed]
I have found that my code causes my Excel to 'not respond' when it gets to this for loop, For thisRow = 2 To lastWSrow(outWS). I'm guessing this is because I am ...
0
votes
3
answers
295
views
Transforming tabular view of data in an Excel sheet into a vertical view
I have the following code that works correctly on small data-sets, but times out and crashes on large data sets. The goal of this code is to take a tabular view of data on one sheet and transform it ...
1
vote
2
answers
116
views
Grab data from one sheet and insert/format it into another sheet
I have code that runs and does what I want it to do with the click of the command button, however when executing, it runs very slow.
The code grabs data from one sheet and inserts/formats it into ...
1
vote
3
answers
69
views
Substitute Excel-Workbook reference for another
I have an Excel-Workbook, where we have an sheet where we consolidate data. Basically we link to other Excel-Workbooks. I wrote the following Macro, in order to update the path and filename. We cannot ...
2
votes
3
answers
830
views
Filtering rows in Excel according to words, dates, and ID numbers
I have 3 columns of ID, Field, and Date (Apologies, I do not know how to format so everything is neat in 3 columns):
...
2
votes
1
answer
10k
views
Compare two Excel workbooks, and create a new sheet containing the differences
I have code that scans and compares two Excel workbooks, and then pastes all of the differences between the two into a new sheet. My code is working properly -
the only problem is when the Excel ...
1
vote
1
answer
56
views
Add spaces around variable with $ symbol bookends
I have some code in a particular coding language, and I am trying to clean it up by adding spaces around the variables. I wrote this code, and it works on small amounts of text and if I set a break ...