Does anyone know how to pass a blank value through an action button to a worksheet cell?
Conceptually, Im trying to make it so that when you click the action button it clears out the data in a cell. If I don't put anything in the value under the advanced options it doesn't do anything. So far the only thing I can do is pass a single space.
Pass a blank value in Action Button
-
- Community Contributor
- Posts: 349
- Joined: Tue Aug 17, 2010 6:31 am
- OLAP Product: Planning Analytics
- Version: 2.0.5
- Excel Version: 2016
-
- Community Contributor
- Posts: 349
- Joined: Tue Aug 17, 2010 6:31 am
- OLAP Product: Planning Analytics
- Version: 2.0.5
- Excel Version: 2016
Re: Pass a blank value in Action Button
Edited, using a reference to an existing blank cell does not work