Results 1 to 20 of 39

Thread: AutoFilter Percent Values +-5%

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #28
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,970
    What do you get if in the Immediate pane you type:
    ?">=" & 3.3
    and press Enter?
    >=3.3
    or
    >=3,3

    ?

    To make my last suggestion work in more locales consider also:
    crit1 = Replace(">=" & MinValue, ".", Application.International(xlDecimalSeparator))
    crit2 = Replace("<=" & MaxValue, ".", Application.International(xlDecimalSeparator))
    Last edited by p45cal; 09-06-2020 at 12:38 PM.
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

Tags for this 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
  •