This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
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).
You should now have access to the Fast Insider build 15.25.
Does this problem exhibit in 15.25?
Ruuning 15.25 and the error is still there in this new version
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?
Microsoft is building a new VB Editor for Office for Mac. Stick with the Insider Fast program to be the first to see it.