| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Using a macro to make a list from Results
Hi,
I have made a macro that runs another macro and copies the results to a new column thus creating a list. I want to make the macro run over a large number of cycles and create a large list without me having to type in the same command over and over. How can I do this? I have pasted the macro below: Sub Macro8() ' ' Macro8 Macro ' Macro recorded 2/06/2008 by deemo ' ' Application.Run "Iterate2" Range("B1").Select Selection.Copy Range("N8").Select ActiveSheet.Paste Range("F1").Select Selection.Copy Range("O8").Select ActiveSheet.Paste Application.Run "Iterate2" Range("B1").Select Selection.Copy Range("N9").Select ActiveSheet.Paste Range("F1").Select Selection.Copy Range("O9").Select ActiveSheet.Paste Application.Run "Iterate2" Range("B1").Select Selection.Copy Range("N10").Select ActiveSheet.Paste Range("F1").Select Selection.Copy Range("O10").Select ActiveSheet.Paste End Sub Thanks! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Using a macro to make a list from Results
On Jun 2, 7:03*am, deemo85 wrote:
Hi, I have made a macro that runs another macro and copies the results to a new column thus creating a list. I want to make the macro run over a large number of cycles and create a large list without me having to type in the same command over and over. How can I do this? I have pasted the macro below: Sub Macro8() ' ' Macro8 Macro ' Macro recorded 2/06/2008 by deemo ' ' Application.Run "Iterate2" Range("B1").Select Selection.Copy Range("N8").Select ActiveSheet.Paste Range("F1").Select Selection.Copy Range("O8").Select ActiveSheet.Paste Application.Run "Iterate2" Range("B1").Select Selection.Copy Range("N9").Select ActiveSheet.Paste Range("F1").Select Selection.Copy Range("O9").Select ActiveSheet.Paste Application.Run "Iterate2" Range("B1").Select Selection.Copy Range("N10").Select ActiveSheet.Paste Range("F1").Select Selection.Copy Range("O10").Select ActiveSheet.Paste End Sub Thanks! See your posting in the Programming group. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a macro to make a list from results | Excel Discussion (Misc queries) | |||
| Using a Macro to make a list from results | Excel Discussion (Misc queries) | |||
| Help with Macro - Make Dropdown List Temporarily Wider | Excel Discussion (Misc queries) | |||
| Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
| Macro to make a cum list | Excel Worksheet Functions | |||
Linear Mode
