ExecuteExcel4Macro "SET.PRINT.AREA" Syntax
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?? |
ExecuteExcel4Macro "SET.PRINT.AREA" 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?? |
ExecuteExcel4Macro "SET.PRINT.AREA" Syntax
Thanks a lot.
It Worked |
All times are GMT +1. The time now is 12:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com