+ Reply to Thread
Results 1 to 2 of 2

Macro pasting value in relative cell

  1. #1
    Registered User
    Join Date
    05-17-2012
    Location
    United States
    MS-Off Ver
    365
    Posts
    6

    Macro pasting value in relative cell

    I want to be able to copy the value in L4 and paste it in any given cell in Column C.

    Right now the macros only copies the value and L4, but it can't paste (special) it in the corresponding cell in Column C without changing the active cell. I want to be able to automatically paste it into the cell in Column C after the value in L4 is copied.

    The cell will be different in Column C each time I run the macro.

    Does this make any sense?
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    02-07-2012
    Location
    MIA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    429

    Re: Macro pasting value in relative cell

    If you only care about copying the value, this will work better:

    Please Login or Register  to view this content.
    No selecting
    .?*??)
    `?.???.?*??)?.?*?)
    (?.?? (?.?
    Pichingualas <---
    ??????????????????????????

    Wrap your code with CODE TAGS.
    Thank those who helped you, Don't forget to add to their REPUTATION!!! (click on the star below their post).
    Please mark your threads as [SOLVED] when they are (Thread Tools->Mark thread as Solved).

+ Reply to Thread

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