+ Reply to Thread
Results 1 to 6 of 6

Copy VBA down to next value in active column

  1. #1
    Forum Contributor
    Join Date
    05-24-2020
    Location
    London
    MS-Off Ver
    Office 365 pro
    Posts
    177

    Copy VBA down to next value in active column

    Hello, everyone,
    I actually have a working code, or so I thought.
    But it doesn't work with this table.

    Can someone help me figure out what's wrong.
    The dates in column A (in the code please active column, it can also be B or C) should be copied down until the next date comes in A and then it should be copied down until there are no more data in the table.

    Here is the code:
    Please Login or Register  to view this content.
    Fehler.png

    The table is inserted.

    Thank you very much for your help
    Attached Files Attached Files
    Last edited by CoSinus; 06-20-2020 at 07:10 AM.

  2. #2
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,712

    Re: Copy VBA down to next value in active column

    Hi CoSinus,

    How about the below code ?

    Please Login or Register  to view this content.
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Copy VBA down to next value in active column

    How about
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    05-24-2020
    Location
    London
    MS-Off Ver
    Office 365 pro
    Posts
    177

    Re: Copy VBA down to next value in active column

    Both Codes are perfect.
    thank you very, very much.

  5. #5
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,712

    Re: Copy VBA down to next value in active column

    Glad to help & thanks for your feedback

    If that takes care of your original request, please mark this thread as 'SOLVED' from the Thread Tools at the top menu & consider Adding Reputation to those who have helped by hitting the Star button under their user names

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Copy VBA down to next value in active column

    You're welcome & thanks for the feedback.

+ 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. VBA to copy a value until new value in Active column
    By CoSinus in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-25-2020, 05:52 AM
  2. Copy Selected active cells down to right column
    By Grahamfeeley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2018, 09:07 PM
  3. [SOLVED] UNSOLVED - Identify highlighted cells in column, copy cell value to column B of active row
    By Armitage2k in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-16-2014, 04:42 AM
  4. [SOLVED] Copy active cells from one column as a sequence in another cell
    By adihad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2013, 03:59 AM
  5. Search for Value in Closed Workbook and copy Column to Active Sheet Column BE
    By Winon in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-19-2011, 12:57 PM
  6. Macro to copy column from multiple workbooks and transpose in active book
    By kishen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2011, 05:48 AM
  7. Marco to copy from active cell to top of column
    By Balthasar G in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-09-2006, 08:29 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