Some guidance with this code would be much appreciated.
In a nutshell I try to show only filtered data (visible rows) from table in my multi column list box. I managed to get it working by copying filtered data and pasting to new table (filtered_tbl) and referencing that, but I thought it was a bit of a clunky solution and seemed to create problems in other areas of my form when text boxes etc. were not sure which table (actions_tbl or filtered_tbl to reference), so I thought I would go back and have another stab at trying to set the range from the original table with the filters applied.
Below code generates Run time error '70': Permission denied error, when I click debug, it highlights following line
The full code is here (adapted from another forum post I found);Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks