Hello Excellists --
Does anyone know of a good way to 'hold' all the formatting that goes with a cell, or more specifically a large group of cells?
I want to take a group of cells and apply total formatting (font, fill, borders, etc.) to another group of cells. -- not copy | paste formats, please -- not what I'm after in this case.
The larger picture is that I am copying a range of cells to a variant array, then filtering this array to pass a subset to another array, then applying the second array to a range. To this range I would like to lay over the formatting from the original cells.
So I need an efficient way to transport a range of cells (size approx 400 rows x 400 columns) to another range, via code. I try to handle this kind of stuff in arrays, but haven't got a good way to get the whole format 'package' of a cell without looping through a bunch of its properties.
Thanks much!
Does anyone know of a good way to 'hold' all the formatting that goes with a cell, or more specifically a large group of cells?
I want to take a group of cells and apply total formatting (font, fill, borders, etc.) to another group of cells. -- not copy | paste formats, please -- not what I'm after in this case.
The larger picture is that I am copying a range of cells to a variant array, then filtering this array to pass a subset to another array, then applying the second array to a range. To this range I would like to lay over the formatting from the original cells.
So I need an efficient way to transport a range of cells (size approx 400 rows x 400 columns) to another range, via code. I try to handle this kind of stuff in arrays, but haven't got a good way to get the whole format 'package' of a cell without looping through a bunch of its properties.
Thanks much!
