Copy recent date
Results 1 to 4 of 4

Thread: Copy recent date

  1. #1
    Board Regular
    Join Date
    Mar 2014
    Location
    cyprus
    Posts
    733
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Copy recent date

    Hi to all in forum, Im kindly require to provide me support sso that a VBA code, should run through col. "A" and where find the newest date should copying this date in cell "A500".

    Please see below an extract.

    09/06/2019
    15/06/2019
    21/06/2019

    Based on above extract the code should copying the date "21/06/2019"
    Thank you all in advance
    Last edited by Panoos64; Jul 12th, 2019 at 02:42 AM.

  2. #2
    Board Regular
    Join Date
    Oct 2014
    Location
    UK
    Posts
    3,826
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Copy recent date

    try

    Code:
    Sub Recent_date()
        Range("A500").Value = WorksheetFunction.Max(Range("A1:A499"))
    End Sub

  3. #3
    Board Regular
    Join Date
    Mar 2014
    Location
    cyprus
    Posts
    733
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copy recent date

    Perfect Alan, thank you so much for your time spent for my project. Hv a great day!

  4. #4
    Board Regular
    Join Date
    Oct 2014
    Location
    UK
    Posts
    3,826
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Copy recent date

    you're welcome

Some videos you may like

User Tag List

Tags for this Thread

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
  •