Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Message to advise when values <>0

    I have the word "check" in col A and values in Col B to Q in the same row as the word "check"

    The values in line with the word "check" should be zero and if not a message box must appear showing the sheet name and row number where the values is not zero. Small values where the tolerance is more than 5 decimal places can be ignored for eg 0.00001 or -0.00001 to be ignored

    The following code attached works well , except the where the value that is in the same row asthe work "check" is negative, it is ignored. The code must be amended to show the row number where the value in the same row as "check" is negative

    Your assistance is most appreciated
    Attached Files Attached Files
    Last edited by HowardC; 2012-10-31 at 13:55.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Could you attach a sample file and elaborate more on exactly what you want to happen with the macro?Steve

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Hi Steve

    Thanks for the reply. I managed to tweak the code and so far it is working fine.

Posting Permissions

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