Object required error

I'm trying to get a new piece of code to work, by modifying a very useful section of code from Leith Ross. His original code is referenced below.

Please Login or Register  to view this content.

The only problem with that approach is that it always checks the same cell for the "END" trigger, when I need it to check the next cell. I modified it to the code below.

Please Login or Register  to view this content.

This should do the exact same thing, but this code should use the exact number of "c" required. The problem is that I get run-time error 424, object required. I can't figure out how my code is that much different that it wouldn't work.

This code is all embedded in the cmdSelect button in userform1. Please reference original thread here.
http://www.excelforum.com/excel-prog...d-trigger.html

Thanks!

I actually got the following to work.

Thanks for the tip!

Please Login or Register  to view this content.

I actually got the following to work.

Thanks for the tip!

Please Login or Register  to view this content.