+ Reply to Thread
Results 1 to 3 of 3

Selection change - Copy & Paste values

  1. #1
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    607

    Selection change - Copy & Paste values

    Hi gurus,

    Trying to build a project and got stuck on one piece of code.

    Assume you got formulas in A1:Z1. I would like macros to copy that range and paste values in A10:Z10. But... There is a catch. I want the copy range changing according to selected column. Example:

    If I have selected any cell in C column - copy & paste range changes to C:Z, if G column selected - range is G:Z etc. So, the beginning range changes according to selected column and Z is always fixed.

    How do I do this? Please bare with me, I am a very beginner in VBA...
    Last edited by ABSTRAKTUS; 09-28-2014 at 11:30 AM.

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,347

    Re: Selection change - Copy & Paste values

    Hi ABSTRAKTUS,
    maybe so
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    607

    Re: Selection change - Copy & Paste values

    Straight on target! Thanks a lot mate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy/paste values from multiple selection into new workbook
    By gigi85 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2014, 10:37 AM
  2. Using current month selection to copy/paste formulas and values
    By gigi85 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-03-2014, 07:51 AM
  3. Instantly change column values after copy/insert rows based on input - Selection parameter
    By BuzzOffSweetheart in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2012, 09:47 AM
  4. [SOLVED] Change existing MACRO to only copy/paste Values
    By williampdx in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2012, 08:07 PM
  5. Excel Button to copy selection and then paste special values over it
    By transportplanner in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-14-2011, 07:00 AM

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