Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I keep getting the following error "Compile Error: Loop without Do" I am checking to see if A13 is empty if it is then enter the value in txtorganization in cell A13 then end loop else increase cellposition by 1 and repeat the process... any ideas how to solve this error?? Private Sub cmdInsert_Click() Dim CellPosition, counter counter = 1 CellPosition = a13 Do While counter <= 10 If [CellPosition].Value = " " Then [CellPosition].Value = txtOrganization.Value Exit Do Else CellPosition = a13 + 1 counter = counter + 1 Loop End Sub -- cedtech23 ------------------------------------------------------------------------ cedtech23's Profile: http://www.excelforum.com/member.php...o&userid=31022 View this thread: http://www.excelforum.com/showthread...hreadid=507400 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
VBAProject name compile error, not defined at compile time | Excel Programming | |||
Compile error: Loop WIthout Do | Excel Programming | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |