Sheets("Sheet1").Activate crashing VBA code

[wackywoo105]

This happened with access a couple of days ago.

AppActivate "Access"

started to crash when it has been working forever. I just commented out that line.

Now an excel file with

Sheets("Sheet1").Activate

is failing at that point.

Can anyone help with why and how to fix it ?

I have to say I'm getting tired of MS updates breaking things that have been working fine for years.

 

[Skyybot]

Try

Workbooks("YourWorkbookName.xlsm").Sheets("Sheet1").Activate

. Make sure that you Sheet name is still named Sheet1. Depending on where your Macro resides you could also use

ThisWorkbook.Sheets("Sheet1").Activate

 

[wackywoo105]

Try

Workbooks("YourWorkbookName.xlsm").Sheets("Sheet1").Activate

. Make sure that you Sheet name is still named Sheet1. Depending on where your Macro resides you could also use

ThisWorkbook.Sheets("Sheet1").Activate

Thanks. That appears to have done it. I think years of shoddy code is finally catching up with me.

Oddly I had done it the way you said elsewhere, it was just this one line.

Is there a particular reason Excel suddenly doesn't like it?

You don't happen to know an alternative for the Access one do you? (sorry I know wrong place).

 

[Skyybot]

Most likely there is another Workbook that opens in the background. Either PERSONAL template, or some add-ins, so you have to specify which Workbook your Sheet is in. Sorry, I don't use Access but you could try

AppActivate "Microsoft Access"