Results 1 to 4 of 4

to exit main procedure from procedure called by yhe main

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-28-2010
    Location
    delhi,india
    MS-Off Ver
    Excel 2007
    Posts
    128

    to exit main procedure from procedure called by yhe main

    Hi all,
    i am using a code that loops through a range and finds if any cell is empty.On finding one i use msgbox as-"The cell is empty".
    However I want to display the cell which is empty in msgbox.

    code used is shown:-
    Rng1.Select
           For Each Rng1 In Selection
           If Rng1.Value = "" Then
           'Set r = ActiveCell
           MsgBox "The cell is empty"
           
           End If
           Next Rng1
    any help will be appreciated.
    Last edited by Andy Pope; 09-27-2010 at 09:55 AM.

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