PDA

View Full Version : [SOLVED] Excel 2010 vs. 2016 Functions won't Work



sherryjoo
08-16-2016, 12:54 PM
Hi - I work at a small site for a large corporation. They have decided to push out 2016 to all users in a wave. I can't request the software myself so I could test it. I just have to wait. The issue is that some of my users on the production floor have already been upgraded and the macros I had written for them no longer work. Specifically these;

Format(Date, "MM/DD/YYYY")
SCELL = Date & " " & Time

At least these are the first failures. I can post more code if you need it.

Can someone tell me why it would fail for something so basic? Perhaps I'm missing something? Normally I would try to research/test and find the answer, but I don't really have the time since production is down.

Any advice/direction would be greatly appreciated!!

Thanks,
Sherryjoo

Paul_Hossler
08-16-2016, 01:14 PM
1. What's the entire macro (or least enough that shows the error)?

2. What specifically "doesn't work?"