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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.