Excel VBA Application.Goto error introduced in 15.23 and work around

Question

Excel VBA Application.Goto error introduced in 15.23 and work around

Anonymous

Hi

It seems upgrade to 15.23 causes a 1004 error if you use Application.Goto to get to a named range and the worksheet where the named range exists is not the active worksheet.

You can get around this by using the Activate method to get to the worksheet first before using Application.Goto.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Answer 1

Jim G 134K MVP

Microsoft is building a new VB Editor for Office for Mac. Stick with the Insider Fast program to be the first to see it.

0 comments

Answer 2

Can't get onto client site ATM to check, but mjnaylor8 says not. Incidentally, I had to come home to edit code in Windows version as Mac VBA editing is so severely disabled. No variable values shown on hover, no editing toolbar, just horrible. I thought the versions were supposed to be the same once we got to 2016?

Answer 3

Anonymous

Ruuning 15.25 and the error is still there in this new version

0 comments

Answer 4

Jim G 134K MVP

You should now have access to the Fast Insider build 15.25.

Does this problem exhibit in 15.25?

0 comments

Answer 5

Thanks for this - a godsend that I was able to find this answer so quickly. I had a panic from a client whose spreadsheet macro suddenly failed after years of successful use. It worked fine on my (Windows) PC, so I suspected it was something to do with the Mac version! Now to check and change all the code for all my Mac clients (sigh).