Code suddenly started failing - not sure why!

Hello all,

Long time lurker - first time poster!

I'm looking I'm looking for help on this very curious issue that started happening this morning.

I have a spreadsheet that I've been using this macro with to sort a range based on specific column headers. Up until this morning - it has worked without an issue. But when I tried to run the code this morning I was greeted with the following error:

error code.jpg

Debugging brings me here:

error vba.jpg


And here is the code in full:

Please Login or Register  to view this content.

But here is what is confusing me the most. First - it worked just fine yesterday and all the days prior. Secondly, if the data is pasted into the workbook, saved, the workbook closed and reopened - it works just fine. If I paste it into excel and try to run the code immediately it fails.

Where am I going wrong?


Any help would be greatly appreciated

Hi,

check first the value of the variable in the codeline where the error occurs …