About Us

BadMammaJ

I need some help. I am trying to get my macro code to loop over multiple lines to the end of my worksheet.

I have started with this code so far

Code:

Range("A2:F2").Select
    Selection.Copy
    Range("A3:F48").Select
    Selection.Insert Shift:=xlDown
    Sheets("Sheet6").Select
    Application.CutCopyMode = False
    Selection.Copy
    Sheets("Sheet7").Select
    Range("G2").Select
    ActiveSheet.Paste
    ActiveWindow.SmallScroll Down:=27
End Sub

I need this to loop from the top to the bottom, but not sure how that would work because by the time this runs, I'm 47 lines down from where I started. I'm new to macros. If I can get this to work, it will save me a month's worth of work.

Thanks

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I want to loop this macro	DoooWhat	Excel Programming	2	August 2nd 10 02:09 PM
Macro Loop	stan	Excel Discussion (Misc queries)	1	October 22nd 09 04:38 PM
Loop to run macro each row	PST	Excel Discussion (Misc queries)	1	May 17th 07 06:36 AM
Do until loop with use of another macro in loop	The Excelerator	Excel Programming	9	February 28th 07 02:28 AM
I Need Help with my loop macro	Pete	Excel Programming	1	January 16th 04 04:02 PM

Menu

About Us