+ Reply to Thread
Results 1 to 4 of 4

Can anyone break this code down for me?

  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:

    Please Login or Register  to view this content.
    Last edited by FDibbins; 04-29-2014 at 06:21 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Can anyone break this code down for me?

    For future reference, please use code tags when posting code (see my note below on how to)

    I will add them for you - this time
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

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

    Re: Can anyone break this code down for me?

    Quote Originally Posted by FDibbins View Post
    For future reference, please use code tags when posting code (see my note below on how to)

    I will add them for you - this time
    Sorry about that. I'll be sure to do that next time.

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Can anyone break this code down for me?

    It selects A2, unprotects the sheet, then adds a new row to the Table, selects the last row (the new one) and protects the sheet again. I assume you know that since you know what it does so I don't really understand what you are asking?
    Remember what the dormouse said
    Feed your head

+ Reply to Thread

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. [SOLVED] 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