PDA

View Full Version : Getting Error when No visible Cells found. What to do?



prabhafriend
07-05-2011, 07:34 AM
I am having a scenario where I may get blank values in a listcolumn of a List. How to skip those steps if there is no blank cells are "visible" after filtering for a blank. I can't even able to check cells.specialcells(xlcelltypevisible).count when the scenario occurs. Please help.

Aflatoon
07-05-2011, 07:48 AM
Since you have a header row while filtering, then you can test if the count of visiblecells in one column is greater than 1.