Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile Error: Next Without for
OK guys,
What is it I am doing wrong. I get a compile error (Next without For) on the following piece of VBA: For i = 2 To Lengte If MyArray(i) < " " Then TekstOut(j) = MyArray(i) j = j + 1 Else k = i - 1 If MyArray(k) = " " Then j = j + 1 Else TekstOut(j) = MyArray(i) j = j + 1 End End Next Do you have clue? TIA, Remco |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile Error: Next Without for
Remco,
Change your "End" statements to "End If". -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Remco" wrote in message m... OK guys, What is it I am doing wrong. I get a compile error (Next without For) on the following piece of VBA: For i = 2 To Lengte If MyArray(i) < " " Then TekstOut(j) = MyArray(i) j = j + 1 Else k = i - 1 If MyArray(k) = " " Then j = j + 1 Else TekstOut(j) = MyArray(i) j = j + 1 End End Next Do you have clue? TIA, Remco |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver - error - Compile Error | Excel Discussion (Misc queries) | |||
help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
VBA Error Message "Compile Error...." | Excel Discussion (Misc queries) | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |