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
Resolved · High Priority · Version 2007
VBA Copy cell format to destination cell
How can you copy cell format to destination cell?For upcoming training course dates see: Pricing & availability
RE: VBA Copy cell format to destination cell
Hi ShaminThanks 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:=xlPasteFormatsRegards
Stephen
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
|
|
» Forum post: More information on lookup |
How Better Organisation Can Mean A Better Coordinated Business It's perfectly common, across countless organisations, for one part of the company not to understand enough about another - 'the right hand doesn't know what the left is doing', as they say. It's common, but also a serious failing, and one that's surprisingly easy to address. » Article: Organisational skills training london |



Course updates

