Results 1 to 11 of 11

Help with macro shortening

Threaded View

M4RSH Help with macro shortening 06-06-2014, 04:18 AM
zbor Re: Can this Macro be... 06-06-2014, 04:19 AM
zbor Re: Can this Macro be... 06-06-2014, 04:19 AM
M4RSH Re: Help with macro shortening 06-06-2014, 04:27 AM
zbor Re: Help with macro shortening 06-06-2014, 04:37 AM
M4RSH Re: Help with macro shortening 06-06-2014, 04:55 AM
M4RSH Re: Help with macro shortening 06-06-2014, 06:46 AM
zbor Re: Help with macro shortening 06-06-2014, 07:16 AM
M4RSH Re: Help with macro shortening 06-06-2014, 09:02 AM
zbor Re: Help with macro shortening 06-06-2014, 09:34 AM
M4RSH Re: Help with macro shortening 06-12-2014, 07:07 AM
  1. #1
    Registered User
    Join Date
    11-27-2013
    Location
    Leeds, England
    MS-Off Ver
    Excel 2010
    Posts
    41

    Help with macro shortening

    Hi All,

    I'm working on a little project for a friend and the below macro is one of two macros that are my final sticking points. My Questions with this macro are - can the below be simplified? & I need to repeat this macro to a further 14 times, moving the cell selection down 15 rows each time (with the exception of the final 2 points - inputing day, month, year, input name & changing sheet & saving) - is there an easy way to do this?

    
        Range( _
            "W16:X19,T16:U19,Q16:R19,N16:O19,K16:L19,H16:I19,E16:F19,D10:E10,G10:H10,J10:K10,M10:N10,P10:Q10,S10:T10,V10:W10" _
            ).Select
        Selection.ClearContents
        
        Range("D20:F20").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("D21:F21").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("D22:F22").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("G20:I20").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("G21:I21").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("G22:I22").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("J20:L20").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("J21:L21").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("J22:L22").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("M20:O20").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("M21:O21").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("M22:O22").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("P20:R20").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("P21:R21").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("P22:R22").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("S20:U20").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("S21:U21").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("S22:U22").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("V20:X20").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("V21:X21").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("V22:X22").Select
        ActiveCell.FormulaR1C1 = "0"
        Range("D10:E10").Select
        
        Range("Q5:Q6").Select
        ActiveCell.FormulaR1C1 = "Day"
        Range("R5:T6").Select
        ActiveCell.FormulaR1C1 = "Month"
        Range("U5:U6").Select
        ActiveCell.FormulaR1C1 = "Year"
        Range("AF5:AG6").Select
        ActiveCell.FormulaR1C1 = "INPUT NAME"
        Range("D10:E10").Select
    
        Sheets("Menu").Select
        ActiveWorkbook.Save
    Last edited by M4RSH; 06-12-2014 at 07:10 AM.
    All the Best,

    Marshall

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Simplified Macro that copies col A and B from 12 sheets to a Complete sheet
    By programct in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2014, 12:10 PM
  2. [SOLVED] Excel V-Look up Macro Simplified
    By lreed in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2013, 03:59 PM
  3. Simplified Conditional Macro
    By martinez_pedro in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-27-2011, 10:31 PM
  4. Simplified Macro
    By martinez_pedro in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-17-2011, 09:47 AM
  5. Can this be simplified?
    By Niko in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-11-2005, 12:05 PM

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