Problem Search and display all instances of a full/partial match in the first worksheet from all the other worksheets in […]
Tag: excel
Excel-to-JSON parser 2
Problem After first code review I have fixed the found issues. Could you please review my new refactored application? Main […]
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 […]
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 […]
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 […]
Increasingly Long Runtime for Macro
Problem My code works, but the problem is that it is taking an increasingly long time to run, with the […]
Racetrack in… VBA?
Problem So, I took a look at the August Challenge: The top-voted answer is Racetrack1: “In the game of Racetrack2, […]
Raw exchange trade data analysis program
Problem The following is a small snippet from a pretty large program written to analyze raw data and find specific […]
Excel VBA Sub Routine is extremely Slow deleting a Range [closed]
Problem Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add […]