Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 129
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.programming
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort Gavin Excel Worksheet Functions 0 May 17th 07 01:20 PM
Need syntax for RUNning a Word macro with an argument, called from an Excel macro Steve[_84_] Excel Programming 3 July 6th 06 07:42 PM
page setup with Excel4 & Waiting Form Liedson31 Excel Programming 1 June 8th 05 06:46 PM
Start Macro / Stop Macro / Restart Macro Pete[_13_] Excel Programming 2 November 21st 03 05:04 PM
Excel4 Call to get Function String Rob Bovey Excel Programming 6 September 24th 03 06:34 PM


All times are GMT +1. The time now is 12:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"