Thread: check if range containing values
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Markus Serbel Markus Serbel is offline
external usenet poster
  
Posts: 7
Default check if range containing values
J.E. McGimpsey wrote:
Dim numVals As Integer
numVals = Application.CountA(Range("A1:A5"))
If numVals = 0 Then MsgBox "All Empty"

thank you! :)
markus
Reply With QuoteReply With Quote