| View previous topic :: View next topic |
| Author |
Message |
ByteKiller
Newbie
Joined: 21 Sep 2009
Posts: 3
|
 Posted: Mon Sep 21, 2009 1:57 am Post subject: Alternating Row Insertion Macro [SOLVED] |
 |
|
Hello there, first off I am new to forums so hello to all! I did a search to see if anything came close to what I was looking for but was greeted with several hundred pages of results many of which had no relevance whatsoever so I do apologise if this has previously been discussed.
I am new to OpenOffice Basic but I managed to write a macro for the insertion of rows into a spreadsheet. However, what I want to accomplish is this.
For a specified range of rows, loop through range and insert alternating rows (i.e. insert a row, skip to next row, insert another row and so on) as opposed to inserting them one after the other.
I'm certain this is possible in OpenOffice but I am having great trouble in writing the macro. Can anyone give me any pointers or assistance?
Last edited by ByteKiller on Mon Sep 21, 2009 6:47 am; edited 1 time in total |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
|
| Back to top |
|
|
ByteKiller
Newbie
Joined: 21 Sep 2009
Posts: 3
|
| Posted: Mon Sep 21, 2009 6:47 am Post subject: |
|
|
| Thank you very much for the links! I should have looked at the API documentation in greater depth than I did because I have managed to write what I wanted now. Thank you once again! |
|
| Back to top |
|
|
|
