View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.