Auto filtering macro help in MS Excel RRS feed

  • Question

  • I created a data base to help track filter and belt changes.

    I successfully made a macro and it worked perfectly for about 10 times. I shut it down, went for lunch, and when I returned it stopped working and gave me an error

    Run time error '1004'

    The command could not be completed by using the range specified
    Select a single cell within the range and try the command again.

    This never happened before and I didn't change anything.

    Monday, September 26, 2016 9:35 PM

All replies

  • Hi,

    Could you please share your code with us for testing?

    Thanks for your understanding.

    Tuesday, September 27, 2016 3:15 AM