RE: Using Results from Macro to create list

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

sorry, its excel

"Wayne-I-M" wrote:

thus creating a list.

Is this access (sounds like excel)

Try this link

http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.misc&lang=en&cr=US

--
Wayne
Manchester, England.



"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
Active***.Paste
Range("F1").Select
Selection.Copy
Range("O8").Select
Active***.Paste
Application.Run "Iterate2"
Range("B1").Select
Selection.Copy
Range("N9").Select
Active***.Paste
Range("F1").Select
Selection.Copy
Range("O9").Select
Active***.Paste
Application.Run "Iterate2"
Range("B1").Select
Selection.Copy
Range("N10").Select
Active***.Paste
Range("F1").Select
Selection.Copy
Range("O10").Select
Active***.Paste
End Sub

Thanks!

.

Quantcast