To whom it may concern
On 27th May, I updated my windows version. Since then, every time I run VBA, my desktop will crash.
I have tried several methods, including restoring office and uninstall windows updates, but all of my efforts failed. I have tried both office 2016 and office 365, but it doesn't help.
I have tried to use safe mode for excel. However, this problem still exists.
I have no System Restore point before.
Here is the information for my computer.
VBA code: (To paste values rather than formulas)
Sub pub_选择性粘贴数值或文本()
' 数值及数字格式
' 快捷键: Ctrl+e
On Error Resume Next
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats
ActiveSheet.PasteSpecial Format:="文本"
End sub
My computer:
设备名称 sj-PC
CPU: Intel(R) Core(TM) i5-8250U CPU @ 1.60GHz 1.80 GHz
RAM: 8.00 GB
版本 Windows 10 家庭中文版
版本号 21H1
安装日期 2021/3/12
操作系统内部版本 19043.985
体验 Windows Feature Experience Pack 120.2212.2020.0
My windows have been updated to the latest version, 21H1.
Thanks for your help to check what's wrong when I use VBA. I know it must be due to windows update.
Yours Sincerely
Jian Shen