Macro to add more lines when perssing button

[dobracik]

Hi guys,

Just quick question - do you know, on how to modify the code, if I woild like to add multiple tmes 20 formulas, when pressing the button?
So far below code add me ony once, even if I press multiple times, only 20 rows :-( How lo loop to loop this this, so always when pressing new lines with formula will be added in the sheet?

Please Login or Register  to view this content.

[Richard Buttrey]

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.