+ Reply to Thread
Results 1 to 6 of 6

Display Count in a message box

  1. #1
    Registered User
    Join Date
    02-24-2013
    Location
    napier nz
    MS-Off Ver
    Excel 2010
    Posts
    11

    Question Display Count in a message box

    Hi Helpers out there.

    I am trying to achieve 2 things by running a macro as the spreadsheet is changed by other macros prior.

    1. display a count of populated cells within a column and the answer pop up in a message box
    2. display a count of populated cells within a column of 2 values within a column (ie "reef" & "genl") and the answers pop up in a message box/es.


    Campbell

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Display Count in a message box

    I am unable to understand what do you mean by the word Populated Cells and please confirm the column Name for better understanding


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    02-24-2013
    Location
    napier nz
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Display Count in a message box

    I mean populated cells , meaning cells that have data. the number of rows will vary each time the macro is run

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Display Count in a message box

    May be try the code like this

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    02-24-2013
    Location
    napier nz
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Display Count in a message box

    brilliant - thankyou very much !!!!

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Display Count in a message box

    Glad it helps you and thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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