View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Problem with if statement

That will give you a syntax error. There can only be one Next for every
For.

In article ,
"Fredrik Wahlgren" wrote:

I haven't tried your code. You should use the debugger to see what it does.
I think that you only expect one of the IF statements to run within each
loop. If so, you should call Next Cell at the end of each IF statement.