Hello All,
I have a workbook that has a worksheet that is about 28000 lines that
one of my sheets does a lookup on. My thing is that top of each column
the labels are sort buttons. So when ever I sort a column you can see a
blue wave becuase my table is so big. I played with turning calculations
off at the beginning of the macro and back on at the end. But when it
turns the calculations back on the calculations automatically start. I
need the calculations on for when who ever is keying into the sheet
it'll populate from my lookup, but for the sort it'll be best if it was
off. But how can I have the best of both worlds.
Hope someone has an answer thanks for the help as always,
Bob


--
robertjtucker
------------------------------------------------------------------------
robertjtucker's Profile: http://www.excelforum.com/member.php...o&userid=21805
View this thread: http://www.excelforum.com/showthread...hreadid=374002