I tried many suntax but they all fail
for example
ExecuteExcel4Macro "SET.PRINT.TITLES(""$2:$2"","""")"
It passes and does not generate an error but the desired rows (or
columns) does not repeat, and nothing appear in the UI dialog box that
shows the rpeating rows and columns.
What is the right syntax??

Try using R1C1 references:

ExecuteExcel4Macro "SET.PRINT.TITLES(""R2"","""")"

In article . com,
"marwan" wrote:

I tried many suntax but they all fail
for example
ExecuteExcel4Macro "SET.PRINT.TITLES(""$2:$2"","""")"
It passes and does not generate an error but the desired rows (or
columns) does not repeat, and nothing appear in the UI dialog box that
shows the rpeating rows and columns.
What is the right syntax??

Thanks a lot.
It Worked