VBA not running on Office 2016

adamdoug

New Member
Joined
May 10, 2016
Messages
4
Hi,

I am wondering if anyone can help me. Today I have upgraded from windows 7 to windows 10 and all the macro enabled worksheets I have previously used have stopped working. It looks like they seem to error around sorting data.

I have also noted that when I record a macro and review the code the majority of it is in red and will not work if re-ran. Does anyone know what I can do to rectify this?

Any help on this is appreciated.
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,503
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Did you only upgrade Windows, or Office too?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,974
Messages
5,525,990
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top