How can I copy a cell with it's formating.

[lok-kok]

Hi you all,
Pls show me the way to copy a cell with it's formating from other sheet.

Ex : copy a cell with it's formating from sheet A to Sheet B.
thanks alot.

[royUK]

Use Copy, PasteSpecial, Formats. If you want VBA then use the macro Recorder whilst doing the copy/paste.

http://www.excel-it.com/record_macro.htm

[lok-kok]

Thanks for your support.
But... how to say?? h

I have a sheet (sheet A) and I want to link data from this sheet to another sheet (Sheet B).
But sheet A contains some merged cells, and I want these cells keep all it's formating in the sheet B. I think u understand what I want.?? Thanks and looking forward to hear from you.

[VBA Noob]

Have you tried paste special > formats

http://www.bettersolutions.com/excel...I216522111.htm


VBA Noob