[RESOLVED] How do I stop Cell Borders from disappearing when a filter is applied?
Good afternoon everyone!
Here's my delimma. I've got a lengthy excel with dozens of rows of data which were created with a VBA macro.
This data is graphically represented by merged, colored, and bordered cells of a variety of lengths.
At different times I need to sort by certain criteria in order to provide a "report". When I do, I find that some of
the top/bottom borders disappear...almost as if they were "stuck" to the adjoining cells that are now hidden by
the filter.
Does anyone know I can overcome this short of manually going through and re-bordering each cell? Is there
some way to make the borders an absolute in some fashion?
Thank you,
Frank M
Re: How do I stop Cell Borders from disappearing when a filter is applied?
Solved my own question. Used "BorderAround" and my borders no longer disappear.