Excel Error (Microsoft Visual Basic)

Hi I've got an issue where one of our users is using a Macros Enabled spreadsheet, every time they go to write something in one of the cells within the Excel workbook and then come out of it again, ...

excel

Macros and VBA

office 365

cam909
Jan 19, 2021
mtarler it turns out that when moving the corrupted Excel file to another location within the network drive, it worked and the errors went away. I think it's possible due to the fact that the location of where the user had this file windows couldn't detect it as the file path was longer than 250 characters

mtarler

Silver Contributor

Jan 11, 2021

cam909 since it is a macro enabled sheet I would open the VBA editor (alt-F11) and then find out what line or subroutine the error is happening (assuming it is happening in a macro). That should help find the problem.

cam909
Copper Contributor
Jan 19, 2021
mtarler it turns out that when moving the corrupted Excel file to another location within the network drive, it worked and the errors went away. I think it's possible due to the fact that the location of where the user had this file windows couldn't detect it as the file path was longer than 250 characters

Forum Discussion

Excel Error (Microsoft Visual Basic)