Complie error : else without if?

[soldout2]

Hi all, I am new to VBA programming. I don't know why the system claim that my "else" without "If" ?

====================================

Please Login or Register  to view this content.

==============


Thank you so much !!

[AB33]

You left out End if just before the end sub
Please wrap your code with tags

[arlu1201]

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

[soldout2]

You left out End if just before the end sub
Please wrap your code with tags

thanks for reminding me to quote,
and I added end if just before end sub
however the problem still exists??

[arlu1201]

Change your code to

Please Login or Register  to view this content.