Results 1 to 7 of 7

Copy active cell to first empty cell in specific column in another sheet

Threaded View

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    15

    Copy active cell to first empty cell in specific column in another sheet

    Hi, I'm looking for a way to copy the current active cell to the first empty cell in Colum G of another sheet.

    I am part of the way with the following code but cannot seem to finish it so that works the way I want

    Sub Button6_Click()
    Dim ws1 As Worksheet, ws2 As Worksheet
        Dim DestRow As Long
        Set ws1 = Sheets("Index")
        Set ws2 = Sheets("Sheet2")
        DestRow = ws2.Cells(Rows.Count, "A").End(xlUp).Row + 1
        ws1.Range("A16").Copy ws2.Range("G" & DestRow)
    End Sub
    This copies A16 and I need to copy the current active cell instead, and currently pastes to G3 and I need it to paste to the first empy cell in column G

    Any help would be really appreciated, Mike
    Last edited by jeffreybrown; 11-25-2017 at 01:47 PM. Reason: Please use code tags!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA to find the nearest empty cell in column F and use that as the active cell.
    By oneblondebrow in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2017, 11:55 AM
  2. Non active cell non active sheet copy row from cell refference.
    By _delete() in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2016, 02:36 AM
  3. Copy paste specific range to last non empty cell in Column A different sheet
    By realrookie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2016, 04:20 PM
  4. [SOLVED] if workbook inactive for 30sec make last empty cell in column b the active cell
    By sspreyer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-30-2013, 09:01 PM
  5. [SOLVED] if cell x in column D has a specific value then copy cell x from column A to sheet B
    By new@excel in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-28-2013, 07:26 PM
  6. Copy values from cell in active row, paste in first empty cell in spesified column.
    By Test123Test in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-19-2012, 05:20 PM
  7. Macro-Copy&Paste Fixed Data Ranges Into Last Empty Cell of Specific Column
    By hailnorm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2009, 10:15 PM

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