All Questions
9
questions
0
votes
0
answers
46
views
Faster method to check if a string is found inside Word Files in a directory and subdirectories
I need to check if a string is found inside a Word File in a directory and subdirectories.
I have tried to use Advanced Search of MS Windows 10, to search inside ...
6
votes
1
answer
448
views
Fastest function to `Remove Duplicate Lines` per each cell
The below function is used to Remove Duplicate Lines per each cell.
It works without problem, but it is slow with a range of only one column and 17k rows.
Actually, ...
4
votes
3
answers
474
views
Excel VBA code midStr() function using left and right position instead of length used with mid()
In the early days of Basic (1970's when i started coding) the midStr() function used left and right positions directly rather than left and length we now use with mid(). I always found it more ...
4
votes
2
answers
931
views
Excel VBA Code for Imperial Length Measure Conversion and Formatting Yards Feet and Inches for English and Spanish
STR2INCHES is an Excel VBA Function that will convert string text for Imperial length measurements to a decimal number of Inches.
It handles both English and Spanish words, abbreviations and symbols ...
1
vote
2
answers
51
views
Trimming strings in non-contiguous spreadsheet ranges
This code is tested and works, but I am needing some guidance on simplifying these loops with non-contiguous ranges. I was thinking an array might be better, but I ...
1
vote
3
answers
722
views
Excel VBA Retrieving a Specific Pattern from String
The following VBA code is in response to a SuperUser question which I found interesting.
What I'm looking for in a response?
Code cleanliness. Can I do more to make the code easier to read and ...
1
vote
1
answer
87
views
Transforming the case of text using Excel VBA
I created a simple user form for my VBA course.
I then created the following VBA code:
...
12
votes
4
answers
2k
views
Delete rows in spreadsheet where cells match some patterns
I have vba code that loops through a large number of records and deletes rows based on criteria. The issue at hand is that it takes far too long to run. I have never actually let it finish because it ...
2
votes
1
answer
688
views
Trimming whitespace in Excel cells
I often receive large Excel-sheets in which data has been inserted via copy and paste. Usually a lot of the cells contain whitespaces at the beginning and the end before / after the actual value.
I ...