Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA Copy cell format to destination cell

VBA Copy cell format to destination cell

ResolvedVersion 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

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Change the Print button so it brings up the Print dialogue box

If you want to bring up the Print dialogue box to check your print settings when you hit the Print button, do the following:

1. Right-click on the toolbar that displays the Print button.

2. Select Customise.

3. Click on the Print button on the toolbar to select it, then hold the left mouse button down and drag the button towards the screen below. The button should come off the toolbar.

4. In the Customise dialogue box on your screen, select the Commands tab.

5. Select File from the Categories list, and then locate the Print... icon (looks like the normal Print button, but the word Print has three dots following it).

6. Click on the Print... icon to select it, then use your left mouse to drag and drop the icon onto the toolbar at the top of the screen.

7. Close the Customise dialogue box.

View all Excel hints and tips

VBA Copy cell format to destination cell

VBA Copy cell format to destination cell

RE: VBA Copy cell format to destination cell

RE: VBA Copy cell format to destination cell

Excel articles

Excel tip:

Change the Print button so it brings up the Print dialogue box