Not clear on what you want done.

What are you copying and to where are you pasting?

Formats generally follow the cells when copying.


Gord Dibben Excel MVP


On Fri, 30 Sep 2005 03:30:25 -0500, rajkumarthakur
<rajkumarthakur.1w5zmd_1128071162.6147@excelforu m-nospam.com wrote:


Hi All,

can any one tell me how to paste a range of data in the same format as
it is copied from different cells.

thank you