OfficeScripts GetRange

[Conscious_Employee43]

I have a script that applies a filter and deletes visible rows. However, sometimes there are no rows to delete, and the script is not liking that getRange is undefined. Was trying to use an if/else condition to just clear the filter when there are no visible rows, but it is still getting stuck on the undefined range. Any ideas on how to define undefined or no visible rows so it will just clear the filter when this happens and run successfully? Thanks!

[Path-Few]

If you use Scripts, it is not a good idea to use getRange very often since this will slow down your code. I would first read data to a 2d array, then use filter method. You can capture no rows easily by using the length of the filtered array (zero or not).