Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
what happens when this code is run?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
what happens when this code is run?
Homework?
-- Don Guillett Microsoft MVP Excel SalesAid Software "xtalenaj" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
what happens when this code is run?
is homework not allowed?
"Don Guillett" wrote: Homework? -- Don Guillett Microsoft MVP Excel SalesAid Software "xtalenaj" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
what happens when this code is run?
Sometimes it's just simpler to test it.
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 -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
what happens when this code is run?
It is not that homework is not allowed, it just does not help you to learn
very much if someone just gives you the answer. BTW the answer to this one is that intCounter will equal the number of iterations that the loop makes before reaching a cell in column A that contains the string "Hello". Were you expecting a number? "xtalenaj" wrote: is homework not allowed? "Don Guillett" wrote: Homework? -- Don Guillett Microsoft MVP Excel SalesAid Software "xtalenaj" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
Modification in the CODE to HIDE rows and columns that start with ZERO (code given) | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming |