Results 1 to 4 of 4

Thread: How to copy format of a column using spin button

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Lightbulb How to copy format of a column using spin button

    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:

    Code:
    Private Sub SpinButton1_SpinUp()
    
    Columns("A").Select
    Selection.Copy
    Columns("C").Select
    
    Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
    SkipBlanks:=False, Transpose:=False
    Application.CutCopyMode = False
    
    End Sub
    Last edited by Zack Barresse; 2014-03-06 at 08:39 PM. Reason: Added CODE tags

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •