| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Compile error for MsgBox copied from Microsoft training example?
From Microsoft training on Loops. Copied the following Do While Loop:
Sub CountRows() x=ActiveCell.Rpw y=ActiveCell.Column z=0 Do While Cells(x,y).Value < "" x=x+1 z=z+1 Loop MsgBox "There are "& z &" rows in the current range." End Sub Microsoft Visual Basic flaged MsgBox in red and stated, "Expected:end of statement" What is wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excell VS Office | Excel Discussion (Misc queries) | |||
| Microsoft should put operating system on hardware not software | Excel Discussion (Misc queries) | |||
| Disk is Full Microsoft Excel | Excel Discussion (Misc queries) | |||
| Installing: Microsoft Excel Feature | Excel Discussion (Misc queries) | |||
| recherche into a special range | Excel Worksheet Functions | |||
Threaded Mode
