I have a sheet that uses a bunch of vlookup formulas that are
referencing a hidden tab. Users select a value from a dropdown and all
data related to that value is pulled from the hidden tab. I am trying
to figure out a way to have excel automatically resize the columns
based on the width of the formula result. I am trying to avoid making
the end users resize everything each time they use it. I think I could
figure out a macro to do this, but then users with certain security
settings may not be able to use it. It is a very crammed sheet as it
is, so I am trying to make it as space efficient as possible. Any
ideas?


--
Kevin Ward
------------------------------------------------------------------------
Kevin Ward's Profile: http://www.excelforum.com/member.php...o&userid=31417
View this thread: http://www.excelforum.com/showthread...hreadid=511122