Results 1 to 3 of 3

Paste special formulas button

This is a discussion on Paste special formulas button within the Excel Questions forums, part of the Question Forums category; I want to create a button on my toolbar for pasting (only) formulas. Does anyone have an idea?? Thanks!...

  1. #1
    New Member
    Join Date
    May 2003
    Posts
    12

    Default Paste special formulas button

    I want to create a button on my toolbar for pasting (only) formulas.
    Does anyone have an idea??

    Thanks!

  2. #2
    Board Regular Atholl's Avatar
    Join Date
    May 2002
    Location
    Scotland
    Posts
    434

    Default

    Try this:

    Sub Paste_Special()

    Selection.PasteSpecial Paste:=xlFormulas, Operation:=xlNone, SkipBlanks:= _
    False, Transpose:=False
    End Sub

    You'll have to create a custom button on your menu and assign this code to it. Also, this assumes that you've already cut or copied something to the clipboard..

    Atholl
    Excel 2000
    Windows XP Pro

  3. #3
    New Member
    Join Date
    May 2003
    Posts
    12

    Default

    It is working!!
    thanks!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com