Thanks Thanks:  0
Likes Likes:  0
Page 1 of 3 123 LastLast
Results 1 to 10 of 28

Thread: copy active cell to same cell in sheet 2.

  1. #1
    New Member
    Join Date
    Apr 2015
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default copy active cell to same cell in sheet 2.

    I want to copy active cell if sheet 1 to same cell in sheet 2 by using vba button. Active cell is not the same each time.
    I use: Range (sheet1!a2).value = range(sheet2!a2) but this does 9nly for the cell a2 and not the active cell each time.

  2. #2
    Board Regular
    Join Date
    Apr 2015
    Location
    IT Jungle
    Posts
    123
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: copy active cell to same cell in sheet 2.

    in VBA, you should use
    Code:
    Sheets("Sheet2").range("A2") = Sheets("Sheet1").range("A2").value
    Currently Have two projects that nears the deadline. So it's a bit hectic here

    Just someone that loves to do programming

    id.linkedin.com/in/williamgowtama

    Remember to backup your data before using the macro

    There's nothing impossible in programming

  3. #3
    Board Regular DILIPandey's Avatar
    Join Date
    Jul 2013
    Location
    Dubai
    Posts
    1,336
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: copy active cell to same cell in sheet 2.

    Hi Stavrosiona,
    I want to copy active cell if sheet 1 to same cell in sheet 2 by using vba button
    Try using "Range("Sheet2!" & ActiveCell.Address).Value = ActiveCell.Value" in your code.


    Regards,
    DILIPandey

  4. #4
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    14,655
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    7 Thread(s)

    Default Re: copy active cell to same cell in sheet 2.

    William.
    This is not what was asked for. He/She want's the value in the active cell to go into the same exact cell in sheets("Sheet2")
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

  5. #5
    New Member
    Join Date
    Apr 2015
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: copy active cell to same cell in sheet 2.

    My answer is this is right.
    I want the value in the active cell to copy into the exact same cell in sheet 2.
    Can someone help on this? Is very difficult to find a solution read the active cell of sheet1 and do an action in the exact cell in sheet2.

  6. #6
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    14,655
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    7 Thread(s)

    Default Re: copy active cell to same cell in sheet 2.

    DILIPandey solution works for me. Did you try that stavrosiona
    Quote Originally Posted by stavrosiona View Post
    My answer is this is right.
    I want the value in the active cell to copy into the exact same cell in sheet 2.
    Can someone help on this? Is very difficult to find a solution read the active cell of sheet1 and do an action in the exact cell in sheet2.
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

  7. #7
    Board Regular
    Join Date
    Apr 2015
    Location
    IT Jungle
    Posts
    123
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: copy active cell to same cell in sheet 2.

    Quote Originally Posted by My Aswer Is This View Post
    William.
    This is not what was asked for. He/She want's the value in the active cell to go into the same exact cell in sheets("Sheet2")
    Sorry i failed to understand what stav wants. DILIPandey's solution is correct
    Currently Have two projects that nears the deadline. So it's a bit hectic here

    Just someone that loves to do programming

    id.linkedin.com/in/williamgowtama

    Remember to backup your data before using the macro

    There's nothing impossible in programming

  8. #8
    New Member
    Join Date
    Apr 2015
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: copy active cell to same cell in sheet 2.

    No. DILIPandey? What is that?

  9. #9
    Board Regular DILIPandey's Avatar
    Join Date
    Jul 2013
    Location
    Dubai
    Posts
    1,336
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: copy active cell to same cell in sheet 2.

    Hi 'My Aswer Is This',

    Thanks for seconding my answer. cheers


    Regards,
    DILIPandey

  10. #10
    Board Regular DILIPandey's Avatar
    Join Date
    Jul 2013
    Location
    Dubai
    Posts
    1,336
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: copy active cell to same cell in sheet 2.

    Hi stavrosiona,

    See post#3.


    Regards,
    DILIPandey

Some videos you may like

User Tag List

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
  •