New2vba:

You are my new hero!

I can't imagine anyone having the persistence and perseverance to write this code.

I don't really know what you are doing or trying to do, but it sure looks to me like there certainly MUST be a better way.

I don't know how you will ever maintain your code and what will you do about price changes or name changes.

You have a worklightsingle and a worklighttwin. What happens when someone decides to change the name of worklighttwin to worklightdouble?

Isn't it time you moved your data into some kind of database (Access, SQL, even an old copy of dBase III) and created some kind of front end application in Visual Basic 6.0 or .Net.

I would think that even writing your complete application in Access would be much better than what you are currently doing.

Like I said, I don't really know what you are doing or tyring to do, but you are my new HERO!

Good Luck