Results 1 to 11 of 11

VBA Looping for copy paste after running analysis

Threaded View

finansator VBA Looping for copy paste... 04-13-2014, 07:00 PM
xladept Re: VBA Looping for copy... 04-13-2014, 08:06 PM
finansator Re: VBA Looping for copy... 04-14-2014, 12:59 AM
finansator Re: VBA Looping for copy... 04-14-2014, 09:57 AM
xladept Re: VBA Looping for copy... 04-14-2014, 02:44 PM
xladept Re: VBA Looping for copy... 04-14-2014, 02:47 PM
finansator Re: VBA Looping for copy... 04-14-2014, 03:42 PM
xladept Re: VBA Looping for copy... 04-14-2014, 07:10 PM
xladept Re: VBA Looping for copy... 04-14-2014, 08:54 PM
finansator Re: VBA Looping for copy... 04-14-2014, 09:34 PM
xladept Re: VBA Looping for copy... 04-14-2014, 09:58 PM
  1. #1
    Registered User
    Join Date
    04-13-2014
    Location
    Vancouver, WA
    MS-Off Ver
    Excel 2007
    Posts
    5

    VBA Looping for copy paste after running analysis

    Hello,

    I need some help with the following VBA. I was unable to get a loop to reliably run my analysis, and thought it may be easier for someone to look at the steps I need repeated. I have locked in specific cells that cannot change, and anything unlocked will need to copy/paste from the row below. I will need this to continue this loop until the dates from the Range B8-B1500 end (Output Tab). Thanks for your help--see below.

    Sub Runner()
    
    'Change Date
    
    Worksheets("Output").Activate
    Range("B8").Select
    Selection.Copy
    
    Worksheets("Analysis").Activate
    Range("$C$10").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    
    'Copy and Paste Outputs From Analysis Tab to Outputs Tab
    
    Range("$G$6").Select
    Selection.Copy
    
    Worksheets("Output").Activate
    Range("D8").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    
    Worksheets("Analysis").Activate
    Range("$G$7").Select
    Selection.Copy
    
    Worksheets("Output").Activate
    Range("E8").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    
    Worksheets("Analysis").Activate
    Range("$G$17").Select
    Selection.Copy
    
    Worksheets("Output").Activate
    Range("F8").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    
    Worksheets("Analysis").Activate
    Range("$H$6").Select
    Selection.Copy
    
    Worksheets("Output").Activate
    Range("G8").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    
    Worksheets("Analysis").Activate
    Range("$H$7").Select
    Selection.Copy
    
    Worksheets("Output").Activate
    Range("H8").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    
    Worksheets("Analysis").Activate
    Range("$H$17").Select
    Selection.Copy
    
    Worksheets("Output").Activate
    Range("I8").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    
    'This is will be repeated until there are no more dates
    
    End Sub
    Last edited by Fotis1991; 04-14-2014 at 10:06 AM. Reason: You need to add code tags to every post!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Help with Looping a copy and paste marco
    By Robert110 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-26-2013, 11:02 AM
  2. [SOLVED] VBA Looping Copy and Paste
    By harrison298 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2012, 11:43 AM
  3. Looping Through Some Sheets to Sort Copy & Paste
    By luke1438 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2010, 12:57 PM
  4. Looping Copy/Paste Macro
    By yuuuh in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-22-2010, 11:56 PM
  5. Looping and copy/paste specific rows
    By Desi_bhai in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2007, 12:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1