Results 1 to 3 of 3

Thread: Solved: VBA IF statement condition issue

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-13-2009, 11:17 AM #2
    Tommy
    Tommy is offline
    VBAX Master Tommy's Avatar
    Joined
    May 2004
    Location
    Houston, TX
    Posts
    1,168
    Location
    Hi boston4415,

    Welcome to vbax!

    Try: 
    If round(Range("ShareTotal"),4) = round(ReportTotal,4) Then
    This will round off the decimals to 4 places, sometimes there is a number way out there as in e-12
    Last edited by Aussiebear; 03-30-2023 at 03:43 PM. Reason: adjusted the code tags
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules