VBA SelectedSheets not working properly

[DanielCol]

Hello,
Why is it that this function always return 1 when used as a Excel function ?

Function NbFeuillesActives()
  NbFeuillesActives = ActiveWindow.SelectedSheets.Count
End Function

Regards.

 

[MARK858]

Have you put the code in a regular module (it should be or you would get a #MAME error but just checking)?

 

[DanielCol]

We name them "standard" modules :

 

[MARK858]

What happens if you press Ctrl + Alt + F9?

 

[DanielCol]

Performs a recalculation, but sticks to "1"

 

[MARK858]

What is the cell formatted as?

 

[DanielCol]

General. No special format.

 

[MARK858]

Afraid I am out of ideas and I can't see anything that I could imagine would cause a locale issue.
If I think of anything else I'll post back

 

[DanielCol]

Thanks anyway indeed.

 

[DanielCol]

Important :
- the function works with Excel 2010
- I am using excel 365 insider channel beta

 

[MARK858]

- I am using excel 365 insider channel beta

Same here (at least when I was running it yesterday, at work now for about 8 hours)