Quick question

  • Thread starter Thread starter DB100
  • Start date Start date
D

DB100

Thanks - That is excellent

The only issue I have is with Dates. What format should the source cell
be so that the autofilter recognises it as a date.

I can copy and paste this info into the auto filter box manually and it
works, but when the Macro runs it cannot find the data that is in the
cell.

This is the finishing touch of a long piece I have been working on and
hope someone can help

Thanks
 
Try converting the date to a long integer or double and supply that as the
argument for the auto filter.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Advanced Filter Error - I cannot spot my Error 3
pasting of variable cell value into macro 2
Macro to filter on most current date. 5
Problem with date formatting 5
Copy Paste with fiter and hide copies filtered and hidden 0
another filtering question 1
remembering the same filtering criteria 13
array-to-row autofilter issue 3

Back
Top