Hi all,
I tried to do error checking of filtered data. If there's no visible data filtered, i wanted it to display " No data visible for your selection" .
Here is my attempt in doing it. But the problem is, when there's no visible data filtered, the code doesnt display " No data visible for your selection" instead it still goes to ELSE condition.
Could anyone help me with this? Thanks in advance.
Please Login or Register to view this content.
Hi, cocobean,
check for the last visible row in the sheet and if the value is greater or equal to 3. If no data is filtered/displayed the rows for the heading still will be made for a range so that there will always be a range by your check even if the range just consists of the heading.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks