Share via

Defining Scope for Names

Anonymous
2018-07-19T09:08:50+00:00

I'm trying to learn how to define scope for names however all of my searches return either VBA solutions (which isn't applicable) or how to define scope with the Windows version of Excel (which references menus that don't exist in the Mac Excel).

Does anyone have experience defining global and local scope on Excel for Mac, Office 365 Home? I can't figure out how to make them work. Using the Define Name menu or the Name Box seems to automatically reference the sheet in the range selector, but if I try to create another named range in another sheet it replaces the first range name. I thought there could be several local named ranges provided they always referenced the local sheet name.

Is it not possible to define scope on Mac Excel?

Thanks in advance.

Microsoft 365 and Office | Excel | For home | Windows

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

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2018-07-24T16:02:01+00:00

    Hi

    This StackOverflow page has an example of using VBA to use scope. I tested this code and it works as expected in Excel for Mac.

    https://stackoverflow.com/questions/1057189/how-to-change-named-range-scope

    0 comments