Thread: How to test for a Row being Visible on a Spreadsheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] niall@removethisgreatgulfhomes.com is offline
external usenet poster
  
Posts: 7
Default How to test for a Row being Visible on a Spreadsheet
Set ran1 = Intersect(Rows(6), Cells.SpecialCells(xlCellTypeVisible))


Thanks to all for your replies.

Rick's intersect statement above works fine.

Keep up the good work.


Niall H


Reply With QuoteReply With Quote