Vba - paste in first empty column cell

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Vba - paste in first empty column cell

  1. #1
    New Member
    Join Date
    Dec 2011
    Posts
    44
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Vba - paste in first empty column cell

     
    Hi there.

    I need the code to paste my selection in worksheet SORT, into the first available cell in column A. Intention is not to overwrite existing values in column A.

    Thanks!


    '
    Sheets("tis").Select
    Range("AC2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.Copy
    Sheets("SORT").Select
    'I need the code to paste my selection in the first available empty cell in column A, so I don't overwrite any existing values in column A


    End Sub

  2. #2
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Vba - paste in first empty column cell

    Try

    Code:
    Sheets("tis").Select
    Range("AC2").Select
    Range(Selection, Selection.End(xlDown)).Copy Destination:=Sheets("SORT").Range("A" & Rows.Count).End(xlUp).Offset(1)
    HTH, Peter
    Please test any code on a copy of your workbook.

  3. #3
    New Member
    Join Date
    Dec 2011
    Posts
    44
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vba - paste in first empty column cell

      
    Thank you! This works!

    Quote Originally Posted by VoG View Post
    Try

    Code:
    Sheets("tis").Select
    Range("AC2").Select
    Range(Selection, Selection.End(xlDown)).Copy Destination:=Sheets("SORT").Range("A" & Rows.Count).End(xlUp).Offset(1)

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
  •  

 

 
DMCA.com