troubleshooting Question

EXCEL VBA comparing entereCompose QuestionNeed help asking?Please enter a description for d date and syatem date

Avatar of dnt2009
dnt2009 asked on
Microsoft OfficeMicrosoft ApplicationsVB Script
3 Comments1 Solution153 ViewsLast Modified:
Hi,

Please find attached codes that I have put together to list all funds that have been entered by the user today on another list. There are 2 worksheets to analyse. Once completed I need to csv the file.

I have issues with comparing the date entered by the user and the system date.
Given the attached sample, I should get 3 rows of date but I randomly get 1 or 2.
could you please help as I don't understand how to fix this issue.

The macro to use is called "Test_Account_NAV"
Thanks,. I have a couple of other macros and function called by the main macro.
dnt
Macro-codes.txt
TestFund-NAV-prices.xlsx
ASKER CERTIFIED SOLUTION
dnt2009

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros