MARKED CELL Macro Function ?

[Former Member]

Dear Experts,

On the lines of MARKED COLUMN and MARKED ROW, is there something for MARKED CELL in Macros?  I seem to need it for a not so fancy... in fact a decent simple requirement. I looked in the function library but can't find one that sounds like MARKED CELL.

The original requirement is this

I enter x in a cell C1, C2, C3,... C10

If C1/C11 is > y, then alert.

If C2/C11 is > y, then alert

....

if C10/C11 is > y, then alert

If I dont use any "advanced" functions like MARKED COLUMNS , the alerts pop up repeatedly every cell each time which means from C1 to C10, I will see the pop up 55 times on consecutive entry of values from C1 to C10, if the condition is met in all cells. while I only need this alert 10 times for 10 cells.

But Marked column is painful for the end user.who is expected to be only scared with the pop up that must happen when he/she enters a value and that should happen only once per entry.

Any other creative way to do it, please suggest.

Thanks

BS

[Former Member · Accepted solution]

Thank you Herr Ulrich Köller,

I don't quite understand the ABAP mambo jambo but seems like someone has done it with with own code.

Wonder why SAP would not offer a function for Marked Cell while I see function codes for inverse trigonometric functions!! but I am very keen to know if someone on this earth ever used hyperbolic functions and binomial distributions for which standard macro functions are available.

SAP is amazing

Regards

BS