Im looking for help in removing blank cells from an array and condensing the array so that all non-zero values are listed in touching cells.
ex:
(blank) value1 (blank) value2
to
value1 value2
thanks.
Im looking for help in removing blank cells from an array and condensing the array so that all non-zero values are listed in touching cells.
ex:
(blank) value1 (blank) value2
to
value1 value2
thanks.
When you delete a cell you have to decide whether to shift the cells below it upward or shift the cells to the right over to the left.
Do you always have a preference as to which you want? Shifting cells up would maintain columns individually, while shifting cells left would keep rows intact.
yes, im sorry---
the previous example was a rows example. I want blanks eliminated and any filled cells shifted to the left.
This code should do what you're looking for. You can either adjust the range as needed (if it's always the same range of cells) or add a few lines to determine either the active selection or the "UsedRange".
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks