ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to add a new row using Excel4 Macro (https://www.excelbanter.com/excel-programming/374255-how-add-new-row-using-excel4-macro.html)

[email protected]

How to add a new row using Excel4 Macro
 
We're trying to create a report with a tool that only understands
formula-macros and doesn't use VBA.

We're desperately wanting to add a blank line in the report.

Does anyone know of a Excel-4 Macro that adds a new row?

Thanks.


Tom Ogilvy

How to add a new row using Excel4 Macro
 
Macro1
=Select("R6")
=Insert(2)
=Return()

or for relative

Macro2
=Select("R[2]")
=Insert(2)
=Return()

--
Regards,
Tom Ogilvy



wrote in message
ps.com...
We're trying to create a report with a tool that only understands
formula-macros and doesn't use VBA.

We're desperately wanting to add a blank line in the report.

Does anyone know of a Excel-4 Macro that adds a new row?

Thanks.





All times are GMT +1. The time now is 10:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com