Thread: help me!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default help me!

As merjet says, we should be able to safely assume that tb is a range
object, and has been set to some range within the workbook somewhere in the
code.

That code is looping based upon some condition, based on an counter variable
called i, and checks whether the cell i rows down within the range tb is
less than x, and that the counter i is less that the number of rows within
the range tb, that is that you haven't looped beyond that range.

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"hieunguyen82" wrote in message
...

I'm a biginner to study VBA in excel, anybody can explain for me some
command line following:
Do While (tb.Cells(i, 1) < x) And (i < tb.Rows.Count)
I don't understand *tb.Cells(i, 1)* và *tb.Rows.Count *?. Thanks so
much.


--
hieunguyen82
------------------------------------------------------------------------
hieunguyen82's Profile: http://www.officehelp.in/member.php?userid=5130
View this thread: http://www.officehelp.in/showthread.php?t=1333577

Posted from - http://www.officehelp.in