Skip to main content
Super User

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

3
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community Bot
    Commented Jul 4 at 15:45
  • 1
    "I've got a column set to short date format of dd/mm/yy but whenever I type anything it just hides all rows." What does that mean? Where and what are you typing?
    – DrMoishe Pippik
    Commented Jul 4 at 16:16
  • Do you know how to debug your macro? You are going to need to determine exactly what the value is that's coming from the field where you enter the filter date value. Ultimately, Excel's dates are stored as numbers (and it's just the formatting that displays them in a friendly date format) - but if the field where you enter the date is formatted as "Text", or formatted in some other way that's not actually putting the underlying number value in the cell that Excel expects, then your comparison is not going to be working properly
    – Craig
    Commented Jul 5 at 0:52