Calling AutoFilter from Listbox

[ABSTRAKTUS]

Hi Gurus!,

What I'm trying to achieve is to have 3 cascading listboxes, that filter out data as selections are made. I got a code that filters, copies and pastes filtered results onto another sheet, where listboxes pick their data from. So I'm trying to call macro from listbox_click. It works for the first listbox, but if I call the same macro from another listbox - it throws an error on red highlighted below:

Please Login or Register  to view this content.

Question, how do I employ the second listbox to complete cascade? Sample attached...

Thanks in advance!

[PFDave]

The issue may occur on this line because you have already applied AutoFilter so you don't need that line in second time round.

What happens if you Debug and comment out that line with '