Hello everyone,
I've been using this handy snippets of VBA codes in this thread (post #51 and thanks @jerrysullivan for the great help!), however in the newest version of Excel (I'm using 2411 Build 18227.20162) it stopped working.
Weirdly enough, there is no error message, but it simply creates a new Sheet called "Detail 1" with the popup box saying "Header: Index not found". Meaning that the
"If IsNumeric(vUniqueIdCol) Then" is failing, but other than that my VBA skills fail me and I don't know how I would fix that.
It was working before, but probably since a few updates, since I don't check that sheet too regularly, it stopped working
If anyone could help me, that would be greatly appreciated.
I've been using this handy snippets of VBA codes in this thread (post #51 and thanks @jerrysullivan for the great help!), however in the newest version of Excel (I'm using 2411 Build 18227.20162) it stopped working.
Weirdly enough, there is no error message, but it simply creates a new Sheet called "Detail 1" with the popup box saying "Header: Index not found". Meaning that the
"If IsNumeric(vUniqueIdCol) Then" is failing, but other than that my VBA skills fail me and I don't know how I would fix that.
It was working before, but probably since a few updates, since I don't check that sheet too regularly, it stopped working
If anyone could help me, that would be greatly appreciated.
