Quote Originally Posted by amanda0210 View Post
Hi npamcpp, I wonder if you can help me?

I am looking to use the above code to temporarily make my drop down list wider (maybe 7.0) and I want the columns to return to their original size of 0.40 even after I select something from the list.

I only want it to apply to a table range from Col. BG thru Col. BTK and rows 6 thru 215. I do not want any other cells to resize in my workbook.

Can you help me?
Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread