VBA Select command is causing my Macro to crash

Asked Feb 07 '20 at 16:20

Active Feb 07 '20 at 16:55

Viewed 41 times

This macro was working for awhile and then suddenly stopped working. whenever I attempt to run the macro now it immediately shuts excel down. I commented out the entire macro and then ran it one line at a time until I found where it started crashing. it's on this line:

Sub Run()
'
' Run Macro
'

'
    Application.ScreenUpdating = False

     Sheets("Index").Select
...

End Sub

Any suggestions? i've read the .Select is bad but I don't have the coding skills to create a workaround.

Thank you!

edited Feb 07 '20 at 16:55

braX

11,506
5
20
33

asked Feb 07 '20 at 16:20

Jaydubs

3

Is there a sheet called "Index" within your active workbook? To learn how to avoid select, look [here](https://stackoverflow.com/q/10714251/9758194) – JvdV Feb 07 '20 at 16:21
yes there is. i rerecorded the macro today. – Jaydubs Feb 07 '20 at 16:30
Do you have any event macros? Like `Sheet Change or Activate`? Also, make sure there is no lagging spaces in sheet name. Will need to be exact match – urdearboy Feb 07 '20 at 16:30
No. what you see is the complete text. everything else is currently commented out. – Jaydubs Feb 07 '20 at 16:38
Are you sure that you run the code from the workbook having the sheet in discussion? Try 'Debug.Print ActiveWorkbook.Name` and maybe you will have a surprise... – FaneDuru Feb 07 '20 at 17:05
1

Delete `...` before `End Sub` – GMalc Feb 07 '20 at 17:07
sorry to be confusing. the ... represents commented lines. – Jaydubs Feb 07 '20 at 18:00
@FaneDuru - I did that, the workbook is correct. – Jaydubs Feb 07 '20 at 18:05

VBA Select command is causing my Macro to crash

0 Answers0