PC Review


Reply
Thread Tools Rate Thread

How to add a new row using Excel4 Macro

 
 
gimme_this_gimme_that@yahoo.com
Guest
Posts: n/a
 
      3rd Oct 2006
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 With Quote
 
 
 
 
Tom Ogilvy
Guest
Posts: n/a
 
      4th Oct 2006
Macro1
=Select("R6")
=Insert(2)
=Return()

or for relative

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

--
Regards,
Tom Ogilvy



<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
What are the parameters for print(,,,,,,,,,,,,,,,) excel4 macro? velvetlady Microsoft Excel Programming 1 15th Dec 2009 08:02 PM
passing arrays to VB via EXCEL4 API cell division Microsoft Excel Misc 1 5th Nov 2004 02:16 PM
Excel4 Macros. Dangers? Jack Schitt Microsoft Excel Discussion 1 9th Sep 2004 07:18 PM
Re: excel4 macros Irfon Microsoft Windows 2000 Applications 1 25th Jul 2003 06:14 PM
excel4 macros Irfon Microsoft Windows 2000 Applications 0 16th Jul 2003 09:24 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:51 AM.