Hi Robert, Maybe I'm a little dense, but what do you want to achieve? I understand that you're comparing two timestamps but it helps if you expl...
Sorry for the delay but this one works I added thsi udf as a test in the code Public Function check_folder_is_valid(myVariant As Variant) A...
i checked the code included my check but it doesn't return any filenames. will need to test some more what's you OS and which excel version are ...
How's your VBA knowledge and which version of Excel are you using? Can you post the code block that you're using now?
I would suggest you include a check for the foldername if it contains RECYCLE skip it.
Hi, which version of Excel? Keep in mind that the TEXT fucntion does not return a numeric value but a text with the number value
Is there a macro that clears the clipboard or something similar. If there is nothing to past then these options are not available or greyed out ...
Is the file on your PC read-Only?
Grat solution, and Riny, you say you're not a big fan of VBA, this, seen the newest developments and functionality which Microsoft is building in I ag...
The rows are hidden when you use the splicer, now I see it but your formula to check Yes/No in F, isn't it much easier to to first add datavalidation ...
Both these files are identical (?) at least by name? And further more, your topic question is an=bout 'ignore HIDDEN cells' but ... there are no hi...
you have to se a variable that retains the file from where you're copying it since this is the 'source workbook'
what it instead of TODAY() you use the serial data for the last day of the current year,?
You know where to find us.
Great, my expertise is not with PQ but it's like programming so I understand. Just holler if you need help.