Many choices instead of Complete...

June 20, 2018 at 11:53:50
Specs: Windows 7
Question from another string...
Track Thread: Solved- Move Row To Another Tab If Complete In Excel 2010

Has anyone used this for multiple options?
I have a drop down box with many names.
I would like the execution to put the row on a tab after a name is selected.
I am running into an error, "Compile error: End If without block If"
Any thoughts?

message edited by jabsaw

See More: Many choices instead of Complete...

Reply ↓  Report •

June 20, 2018 at 12:25:52
Did you change the code that was posted in that thread?

There are 2 If instructions and 2 End If's so there should be no "End If without block If" error.

If you changed the code, then we have no way of helping you unless you post the code that is producing the error.

Please keep in mind that we can't see your workbook from where we are sitting so you have to provide enough details for us to work with.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

Reply ↓  Report •
Related Solutions

Ask Question