Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
Lista Forumurilor Pe Tematici
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login

POZE MRRRR'S FORUM (VIEW ONLY)

Nu sunteti logat.
Nou pe simpatie:
sexyindianca pe Simpatie.ro
Femeie
24 ani
Ilfov
cauta Barbat
24 - 53 ani
Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides / [EXCEL] Copy and Paste Chart Formatting [non-VBA, VBA] Moderat de TRaP, TonyTzu
Autor
Mesaj Pagini: 1
TRaP
Moderator

Inregistrat: acum 6 ani
Postari: 748
Source:

While for doing this you should first copy the chart whose formatting you want to replicate, then select the desired chart, go to HOME - Paste - Paste Special - Formats -OK, you could do this with a simple code (obtained by macro recording the previous method):



Sub PasteChartFormat()
    ActiveSheet.PasteSpecial Format:=2
End Sub


Make that a button in your ribbon or QAT and enjoy pasting formats in 1 click rather than 5.


pus acum 5 ani
   
Pagini: 1  

Mergi la