Thread: Determine if range has NO Blank Cells without looping through each cell in range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Excelenator[_29_] Excelenator[_29_] is offline
external usenet poster
  
Posts: 1
Default Determine if range has NO Blank Cells without looping through each cell in range

I have a range called "PreData" that is 12 rows and 6 columns and I want
to make sure the users fill in data in each of the cells. I am checking
the range in the Workbook_BeforeSave event and the code I am using to do
this is:


Code:
--------------------
Application.Goto Reference:="PreData"
Selection.SpecialCells(xlCellTypeBlanks).Select
--------------------


This works fine EXCEPT when there are no blanks. I know that the
Select is failing, I just don't know how to check it before actually
selecting it.

Any assistance will be appreciated!

Thanks!


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=567685

Reply With QuoteReply With Quote