+ Reply to Thread
Results 1 to 8 of 8

give me explanation of code

  1. #1
    Forum Contributor keshavtale's Avatar
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    528

    give me explanation of code

    can anybody
    EXPLAIN THAT CODE SO
    I CAN UNDERSTAND HOW THAT CODE WORK, I HAVE LITTLE KNOWLEDGE OF VBA
    SEE THE BELOW CODE , i also attached file of that code

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by keshavtale; 02-25-2015 at 08:50 AM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,038

    Re: give me explanation of code

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Never use Merged Cells in Excel

  3. #3
    Forum Contributor keshavtale's Avatar
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    528

    Re: give me explanation of code

    sorry i dont know about that rule, now i posted that thread again can you see that

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,038

    Re: give me explanation of code

    Code start from last row
    Please Login or Register  to view this content.
    Back to the 2nd row (that's why Step is -1)

    And it compare current value in B column with previous one (i.e. B20 with B19)
    Please Login or Register  to view this content.
    And if they are not same it will add one more row
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor keshavtale's Avatar
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    528

    Re: give me explanation of code

    if possible can you give explanation in more detail like what is i in offset(i) and every object like that, please if possible

  6. #6
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,279

    Re: give me explanation of code

    See if this helps. I've put comments in the VBA code to explain what is happening.

    Please Login or Register  to view this content.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  7. #7
    Forum Contributor keshavtale's Avatar
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    528

    Re: give me explanation of code

    ok now i understand thanks for that , can you suggest any book or website to learn vba for
    beginners

  8. #8
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,279

    Re: give me explanation of code

    Hi,

    I like the programming and teaching style of

    http://spreadsheetpage.com/

+ 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. Code Explanation Help Please
    By gerbansprawl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-19-2013, 09:30 AM
  2. [SOLVED] I need VBA explanation on this code please help me!!!
    By venkatpvc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-23-2013, 07:38 PM
  3. [SOLVED] Code explanation please
    By Geordie in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-15-2012, 08:12 AM
  4. explanation of code
    By leanne2011 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2011, 06:50 PM
  5. Code explanation
    By bajdr47 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-06-2011, 12:30 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