+ Reply to Thread
Results 1 to 2 of 2

Error in Data Filter VBA

  1. #1
    Registered User
    Join Date
    04-07-2014
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    21

    Error in Data Filter VBA

    Hi...

    i have recode this VBA from recorder , but when i run this macro it is giving me error in Field 6(which is DATE)..

    here is my code

    Please Login or Register  to view this content.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: Error in Data Filter VBA

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. using google sheets create filter tab does not filter importrange data correctly
    By western in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 02-23-2021, 08:14 AM
  2. Filter data on sheet1 and show visible filter data on sheet 2 in colmn A
    By TAMMY32 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-25-2021, 09:35 PM
  3. Replies: 4
    Last Post: 08-31-2017, 02:52 PM
  4. VBA Advanced Filter - Two Filters Without Deleting Bottom Filter Data In Same Column Range
    By hysterical.useless in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2017, 02:54 PM
  5. Replies: 1
    Last Post: 12-12-2014, 06:46 AM
  6. Replies: 0
    Last Post: 01-16-2014, 10:55 AM
  7. Second Advanced Filter does not work based on the data generated from the filter
    By mucc1928 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2011, 02:42 PM

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