Excel object for range format
<p>I am searching for a way to apply to a destination Excel range the same format of a source range. </p>

<p>Making use of <code>Copy()</code> and <code>PasteSpecial()</code> methods doesn't work because I need to use it inside <code>Worksheet_SelectionChange()</code> and the <code>PasteSpecial()</code> method changes self the selection.</p>

<p><strong>The question is:</strong> </p>

<p>Is there an Excel object which can store the whole set of format features of a single cell or range in order to retrieve them later?</p>