Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,665
- Office Version
- 365
- 2016
- Platform
- Windows
I wish to assign variable mcnt2 to the value of the number of values in a named range. The name of the range is "Modlist2".
I am struggling on how to write the formula in VBA.
... isn't the way apparently.
I am struggling on how to write the formula in VBA.
Code:
mcnt2 = range("Modlist2").Count