Pass a blank value in Action Button

Post Reply
PlanningDev
Community Contributor
Posts: 349
Joined: Tue Aug 17, 2010 6:31 am
OLAP Product: Planning Analytics
Version: 2.0.5
Excel Version: 2016

Pass a blank value in Action Button

Post by PlanningDev »

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.
PlanningDev
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

Post by PlanningDev »

Edited, using a reference to an existing blank cell does not work
Post Reply