Hi,
It is known that the "Sparklines" source data should be in a contiguous range of cells.
I have that data in two non-contiguous ranges: A1:C1 and F1:K1- therefor in order to avoid copying and re-arranging the in helper cells - I assume filling a contiguous VBA Array with those non-contiguous ranges -> Name this Array and apply that name as the "Sparklines" source could be a good idea - but I couldn't figure out how to implement that Array to be the source for a "Sparklines" to be displayed in cell L1.
(It sounds to me as if the best way will be to run the above mentioned procedure via VBA Code).
Any help will be appreciated.
Elm
It is known that the "Sparklines" source data should be in a contiguous range of cells.
I have that data in two non-contiguous ranges: A1:C1 and F1:K1- therefor in order to avoid copying and re-arranging the in helper cells - I assume filling a contiguous VBA Array with those non-contiguous ranges -> Name this Array and apply that name as the "Sparklines" source could be a good idea - but I couldn't figure out how to implement that Array to be the source for a "Sparklines" to be displayed in cell L1.
(It sounds to me as if the best way will be to run the above mentioned procedure via VBA Code).
Any help will be appreciated.
Elm
Last edited: