View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mrsharkspoiler@gmail.com is offline
external usenet poster
 
Posts: 3
Default what happens when this code is run?

In the time it took for you to log on, write the question, which
includes the code!! you could have pasted the code in excel to get the
answer.. LOL




On Nov 16, 5:58 pm, xtalenaj
wrote:
Suppose that an Excel spreadsheet contains the value "Hello" in cell A10 but
is otherwise empty when the following code fragment is executed:

Code:
Dim intCounter As Integer

 intCounter = 1

 Do While Cells(intCounter, 1).Value < "Hello"
 intCounter = intCounter + 1
 Loop
After this code fragment is run, the value of intCounter will be what?