User Profile
Cathi69
Copper Contributor
Joined 7 years ago
User Widgets
Recent Discussions
MS Excel VBA function doesn't work with a range in another sheet
I have a VBA function in Excel that looks at a range myRange and counts the cells that match a colour in a cell myCriteria. It works when the myRange is in the current sheet but doesn't work if the range is in another sheet? Function CountColors(myRange As Range, myCriteria As Range) As Long Dim myCell As Range, myCellColor As Long myCellColor = myCriteria.Interior.ColorIndex For Each myCell In myRange If myCell.Interior.ColorIndex = myCellColor Then CountColors = CountColors + 1 End If Next myCell End Function Can anyone suggest what is wrong with myRange? Thanks in advanceRe: No Live event option under Create
The final answer from Microsoft was: James (Microsoft) Wednesday, November 21, 2018 7:32 PM GMT Hello Cathi, I've determined that the Live events are only available for some particular licenses, the list is available on this site: https://docs.microsoft.com/en-us/stream/live-event-overview Create live events in Microsoft Stream1 Enterprise (E1, E3, E5), Education (A3, A5) Create live events in Microsoft 365 (Teams and/or Yammer with external encoder)2 Enterprise (E3, E5)11 The Microsoft Stream admin must grant permissions to create live events 2 You must be a group owner to create a live event in Yammer This is the summary of the things you're trying to do with Stream right now. You should be able to get a 30 day trial of E3 or E5 if you want to give it a go before you put money into it. Cheers, James Office 365 Support
