Results 1 to 5 of 5

Copy - Paste Special.Values (with extra function) VBA Script needed!

Threaded View

  1. #1
    Registered User
    Join Date
    11-19-2011
    Location
    Eindhoven, Netherlands
    MS-Off Ver
    2002 SP3
    Posts
    3

    Question Copy - Paste Special.Values (with extra function) VBA Script needed!

    Hi All!

    Can somebody help me with the following? I would really appreciate it!

    I would like to create a command button within Excel 2002 SP3 that should launch the following method: I would like to Copy a certain Range ("A2:D2") in a sheet ("Historie") and Paste Special.values into a Range ("E23:H23") within the same sheet.

    But: The next time I click on the command button it should Copy the very same range and Paste Special.Values it into one row lower ("E24:H24").The next time into ("E25:H25") and so on.

    Does anyone know how to write this in VBA language?
    Last edited by Kevin2110; 11-19-2011 at 10:07 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1