+ Reply to Thread
Results 1 to 3 of 3

Checking for Empty Scattered Cells

  1. #1
    Kevin O'Neill
    Guest

    Checking for Empty Scattered Cells

    I'm basically looking to repeat this process for many differnt cells on
    the same sheet. But there is no order to the cells I want to apply it
    threw.

    Suggestions?

    If IsEmpty(Cells(20, 3)) Then
    MsgBox "C&C Press. Zone not filled out on Input Sheet!"
    errors = True
    Exit Function
    End If


  2. #2
    Tom Ogilvy
    Guest

    Re: Checking for Empty Scattered Cells

    Dim rng as Range
    set rng = Range("A1:A10,B9,C11,F3:M3,G9")
    if application.CountA(rng) < rng.count then
    for each cell in rng
    if isempty(cell) then
    msgbox cell.Address & " is empty"
    end if
    Next
    End if

    --
    Regards,
    Tom Ogilvy

    "Kevin O'Neill" <ire.kevin@gmail.com> wrote in message
    news:1135188361.614031.112730@g43g2000cwa.googlegroups.com...
    > I'm basically looking to repeat this process for many differnt cells on
    > the same sheet. But there is no order to the cells I want to apply it
    > threw.
    >
    > Suggestions?
    >
    > If IsEmpty(Cells(20, 3)) Then
    > MsgBox "C&C Press. Zone not filled out on Input Sheet!"
    > errors = True
    > Exit Function
    > End If
    >




  3. #3
    Kevin O'Neill
    Guest

    Re: Checking for Empty Scattered Cells

    Thank you, works like a charm.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1