Sorting a table with a macro - code not working

Hi guys,

I have trying to use Dave Peterson's hidden rectangle VBA on my table, however, VBA editor saying it is unable to run due to the highlighted red line in the code below. I have a worksheet macro in the workbook I am trying to incorporate it, is this likely to be the issue? (I have no experience with macro/VBA) The code works fine in a workbook on it's own. Could any suggest a fix? Thanks!

Please Login or Register  to view this content.

Did you see what the value of : Application.Caller is?
It may not be what you think.

Hi Ranman256,

Thanks for your reply. In truth, I am not sure I understand the question (my VBA knowledge is next to nothing really)?

I also meant to add that the Error Code be raised by the VBA editor is Error 2023.

Let me know if there is anything I can do to help or if any more info is required!