Skip to Content

Macro function to check cell status

Hi,

I need to check within a macro, if a cell/row is ready for data input. So far I only found the function to set the status like cell_input() / row_input(), but no function to check the current status.

Any ideas?

Best Regrds,

Mario

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Apr 12, 2016 at 08:00 AM

    Hi,

    It's the same function you can use.
    When you use "cell_input() = 1/0", you set this property. When you use if "cell_input() = 0/1", you get this property.

    BR,
    Ada

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ada,

      this is unfortunattely not working since this function has only export parameters. Means you cant only set the staus but not read.

      Have already tried to us it, in an IF statment, but it do not return any values.

      BR,

      Mario