Settlemen rules excel macro

[Former Member]

Hello everyone. Many thanks for are reviewing this question.

I am trying to create a macro in order to automatize the settlement rules and I have a question. What VBA code can I use for the macro to recognize the first empty field?

As the image shows, what I want is that the Macro start filling out the information in the settlement rule from the first empty field.

I know this would be the code for the first empty cell in excel:

ActiveSheet.Range("a1").End(xlDown).Offset(1, 0).Select

But I do not know how to do it in SAP

I will realy appreciate your answers

Many thanks!

[Sandra_Rossi]

Do you want to code it using "SAP GUI Scripting" ? (SAP COM Library for scripting dynpros)

If so, you should say it in place of "VBA code" and add that user tag.