Results 1 to 3 of 3

Break down of this VB code

Threaded View

  1. #1
    Registered User
    Join Date
    03-13-2014
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    16

    Break down of this VB code

    Hi, I'm not good in VB codes. Can someone help me understand the meaning of this code. and what does each code does.

    thank you so much.

    Range("M1").Select
    ActiveCell = "Answer"
    lr = Cells(Rows.Count, 1).End(xlUp).Row
    While ActiveCell.Row < lr
    ActiveCell.Offset(1).Select
    For c = 11 To 2 Step -1
    If Cells(ActiveCell.Row, c) > 0 Then GoTo Non0
    Next c
    Non0:
    myCol = c + 1
    i = 0
    For c = myCol To 11
    If Len(Cells(ActiveCell.Row, c)) > 0 Then i = 1 + i
    Next c
    
    ActiveCell = i
    Wend
    End Sub
    Last edited by Intalzky; 03-14-2014 at 08:10 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 11-13-2013, 10:28 AM
  2. 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
  3. [SOLVED] inserting break in code
    By papa jonah in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-21-2005, 09:25 PM
  4. code break message box
    By freekrill in forum Excel General
    Replies: 2
    Last Post: 11-29-2005, 01:30 PM
  5. [SOLVED] Break a long row of code
    By Otto Moehrbach in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-10-2005, 09: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