Results 1 to 4 of 4

Can anyone break this code down for me?

Threaded View

  1. #1
    Registered User
    Join Date
    04-10-2012
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    8

    Can anyone break this code down for me?

    I have this code that I got from someone else and would like help understanding it line by line. Although I know what it does when I run it, I'd like to understand it broken down.

    The code is as follows:

    Sub AddRow()
    
    '
    ' AddRow Macro
    '
    ' Keyboard Shortcut: Ctrl+r
    '
        Range("A2").Select
        ActiveSheet.Unprotect 
        Selection.ListObject.ListRows.Add AlwaysInsert:=True
        Selection.End(xlDown).Select
        ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
            , AllowInsertingRows:=True, AllowDeletingRows:=True, AllowFiltering:=True
    
    End Sub
    Last edited by FDibbins; 04-29-2014 at 06:21 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Break down of this VB code
    By Intalzky in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2014, 08:11 AM
  2. Replies: 1
    Last Post: 11-13-2013, 10:28 AM
  3. [SOLVED] How do I break VBA code into two or more lines?
    By Kasama in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-31-2012, 09:27 PM
  4. Why is there a break in code?
    By Arak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-29-2007, 09:36 AM
  5. inserting break in code
    By papa jonah in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-21-2005, 09:25 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