Hi Everybody,
This question should be reproducible with a random set of data including blank cells. What could be causing Error 2015 and how do I fix it?
As a learning exercise, I am trying to create general purpose syntax which evaluates a statement to find the location of blank cells through a backward (Do) loop, if none are found then the Do is exited. For example:
I have tried Application.WorksheetFunction.Match, Application.Match, .Find and found a few other less popular methods, however, I like the evaluate method above for its general power. Unfortunately it throws Error 2015 and don't know why (well and truly under the character limit). Hopefully this is a clearly worded question, if not, please do not hesitate to ask for further clarification.Please Login or Register to view this content.
Bookmarks