apologies if this links to last post

[Rameses]

How can I copy over cell formatting within excel from one worksheet to another

...i can undertsand it not copying to word but excel to excel ....???? please help!

I have tried more than 1 way of skinning this cat but it is getting the better of me!

 

[Sandeep Warrier]

Hi

A regular copy/paste would copy the value along with formatting.

You could also try Edit | Paste Special | Formats ... though this will not copy the values.
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[Rameses]

hi sandeep

thanks for your reply

however i need to have this as part of th code as am doing this 70 times onto different spreadsheets x70 using different bits of my spreadsheet!

any further advice appreciated

 

[Rameses]

dont know if this helps???

http://www.automateexcel.com/2004/08/18/excel_color_reference_for_colorindex/


?

 

[Sandeep Warrier]

It'll be helpful if you could provide the code where you want to include this. What range to you want to copy? Where do you want to paste it?

This sample code below will copy A1 from sheet 1 and paste it (including formats) to A1 in sheet 2.

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> Test()<br>    Sheets("Sheet1").Range("A1").Copy<br>    Sheets("Sheet2").Range("A1").PasteSpecial Paste:=xlPasteAll<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[Jon von der Heyden]

You need to pursue this in the original thread. All bumps, clarifications and all replies should be continued there. Maintaining two threads of the same question just becomes confusing and frustrates people who are trying to help.

Thread here: http://www.mrexcel.com/forum/showthread.php?t=463907