Thank you for all of this. I now understand why the last selected
column was going to K, and the clear contents resort works great!
I'll rebuild my workbook. Is there anything that I need to watch for
or be careful of when rebuilding? And what might cause a workbook to
become corrupt?
Thank you so much again for your time and help with this!
Frank
On Tue, 19 Apr 2016 15:32:43 +0200, Claus Busch
wrote:
Hi Frank,
Am Tue, 19 Apr 2016 07:28:19 -0400 schrieb Phrank:
Regarding the named ranges, I set them up per Garry's instructions,
and yes, when I put the cursor in the Refers To field, I get a running
boarder around my named range. ...generally. I encountered one
anomaly. I've set a named range for an offset header
(INVFunctionsHdr, which is $B$1), and a named range for the last
column (INVFunctionsLastCol, which is $J$1). This gives me the named
range formula shown below. When I put my cursor in the
INVFunctionsHdr, the running boarder is around B1, as expected. When
I select INVFunctionsLastCol and put my cursor in Refers To, the
running boarder is around J1, again as expected. But when I select
the main INVFunctions named range (as shown below), the running
boarder extends from columns B to column K.
column (INVFunctionsLastCol, which is $J$1) is column 10. With your
formula you extend the range to 10 columns. So you start in B1 this will
be column K. You have to substract 1. (I changed this in the formula)
Also, nothing has changed with respect to the SLOW delete, insert, or
copying formats.
I changed the code and the formula for # INV. But there is no change in
performance. So your workbook also takes long time to open I guess it is
corrupt and you have to create it new.
I inserted code to delete rows. If you select a whole row there will
popup a message box where you can choose if the row should be deleted.
The row is not deleted but the contents are deleted and the table will
be sorted to get rid of the blank row. Don't insert new rows. Write the
data below the table and sort the table.
In this way you can work a little faster with the workbook for the time
you need to create it new.
Look he
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for your workbook to see the changes.
Regards
Claus B.