| View previous topic :: View next topic |
| Author |
Message |
kinpatsu
Newbie
Joined: 24 Nov 2008
Posts: 2
|
 Posted: Mon Nov 24, 2008 11:40 am Post subject: Nested macros |
 |
|
I have created a macro in Calc - let's call it Macro1.
I now want to create a second macro - call it Macro2 - that simply entails running Macro1 10 times in a row.
I never had a problem doing this in Excel 97, but it does not seem to work in Calc. Is there a way to do this? |
|
| Back to top |
|
 |
Mark B
Super User
Joined: 16 Feb 2007
Posts: 852
Location: Lincolnshire, UK
|
| Posted: Mon Nov 24, 2008 11:58 am Post subject: |
|
|
Hi
There shouldn't be any difference in the two - this will work in both:
| Code: |
Sub Macro1
'Do some work
End Sub
Sub Macro2
For i=1 to 10
Macro1
Next i
End Sub
|
Mark
_________________
Mark B's Articles |
|
| Back to top |
|
|
kinpatsu
Newbie
Joined: 24 Nov 2008
Posts: 2
|
| Posted: Mon Nov 24, 2008 12:13 pm Post subject: Thank you |
|
|
| Beautiful! I've been mostly a WYSIWYG macro creator - I use the "record macro" tool and then trust the program to faithfully reproduce the sequence of mouse/keyboard commands I enter - but this makes me think that I should invest a bit of time in learning some simple programming principles. Thank you! |
|
| Back to top |
|
|
|
