VBA Copy cell format to destination cell

Resolved · High Priority · Version 2007

Wed 14 Jul 2010, 16:08 Delegate Shamin said...

Shamin has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course

VBA Copy cell format to destination cell

How can you copy cell format to destination cell?

Thu 15 Jul 2010, 13:49 Trainer Stephen said...

RE: VBA Copy cell format to destination cell

Hi Shamin

Thanks for your question

The quickest method would be to invoke the paste special method. While this does involve using the select method, which is not ideal, it is still probably the optimum technique in this instance.
The following is an example

Range("B3").Select

    Selection.Copy

    Range("F3").Select

    Selection.PasteSpecial Paste:=xlPasteFormats

Regards

Stephen

Thu 15 Jul 2010, 14:19 Delegate Shamin said...

RE: VBA Copy cell format to destination cell

Hi,

Thanks.

But I had the date formatting issue during copy of date column in training with Anthony.

I have posted another question for Anthony as he knows the issue during traing.

Regards
Shamim

Training courses