Problem Closed. This question is off-topic. It is not currently accepting answers. This question does not appear to be a […]
Tag: vba
A ‘flexible’ VBA approach to lookups using arrays, scripting dictionary and user input
Problem In my previous post Optimise compare and match method using scripting.dictionary in VBA I wanted to address optimising the […]
VBA performance with Early Bind vs. Late Bind on called Sub-procedure
Problem I was using early bind to reference the dictionary and realised that some users might not be willing to […]
Show all full/partial search matches in the first worksheet from other worksheets
Problem Search and display all instances of a full/partial match in the first worksheet from all the other worksheets in […]
Function to return a legal name for an Excel range: Follow-up
Problem This Excel VBA function was originally the subject of a previous question on Code Review. This function (Namify()) takes […]
Return a substring containing a certain pattern to VBA
Problem I’ve written in a C++ dll the following function to return to VBA a substring containing a certain pattern, […]
Retrieve data from table with criteria
Problem I have to create a custom table (like a pivot table), where users can find immediately the total of […]
Are these good examples of functions that do one thing only or am I getting a little carried away?
Problem I’m reading Robert C. Martin’s “Clean Code” and for the past few days I’ve been fiddling with its function […]
Function to return a string legal for a range name
Problem I wrote an Excel VBA function that will take a string argument and return a string that is legal […]
Finding the position of a string in a dimension of an array
Problem Given an array and a string and bounds within which to search, I need to find the position of […]