Tyberian1988
New member
- Joined
- Mar 5, 2014
- Messages
- 3
- Reaction score
- 0
- Points
- 0
hello everybody! i'm a new member on this forum and a beginner in programming.I would like to know how to paste the format of column(a) in column(c),(d),(e)...etc using a spin button.I need an increment for the pasted format. Any help, please?
Here is a copy of my code:
Here is a copy of my code:
Code:
[COLOR=#333333]Private Sub SpinButton1_SpinUp()[/COLOR]
[COLOR=#333333]Columns("A").Select[/COLOR]
[COLOR=#333333]Selection.Copy[/COLOR]
[COLOR=#333333]Columns("C").Select[/COLOR]
[COLOR=#333333]Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _[/COLOR]
[COLOR=#333333]SkipBlanks:=False, Transpose:=False[/COLOR]
[COLOR=#333333]Application.CutCopyMode = False[/COLOR]
[COLOR=#333333]End Sub[/COLOR]
Last edited by a moderator: