+ Reply to Thread
Results 1 to 8 of 8

just a smidgeon of correction to VBA sort list code please

  1. 01-05-2016, 12:51 PM #1
    yogup
    yogup is offline
    Registered User
    Join Date
    12-16-2015
    Location
    Essex UK
    MS-Off Ver
    office 365
    Posts
    11

    just a smidgeon of correction to VBA sort list code please

    Hi

    I have this code (below) which copies data from ws "safeguard" ws "log" using an autofilter for today's date. I then want the data in ws "log" to be sorted in descending date order. it does not seem to incorporate the newly added data to the sort though. Any ideas where i am going wrong?

    thanks

    Please Login or Register  to view this content.
    Last edited by yogup; 01-05-2016 at 01:13 PM.
    Reply With QuoteRegister To Reply
  2. 01-05-2016, 12:56 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: just a smidgeon of correction please

    Please take a few minutes to re-read the forum rules, and then edit your post to amend the thread title accordingly and add CODE tags.

    Thanks.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 01-05-2016, 01:11 PM #3
    yogup
    yogup is offline
    Registered User
    Join Date
    12-16-2015
    Location
    Essex UK
    MS-Off Ver
    office 365
    Posts
    11

    Re: just a smidgeon of correction please

    amendments now made, apologies
    Reply With QuoteRegister To Reply
  4. 01-05-2016, 01:32 PM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: just a smidgeon of correction to VBA sort list code please

    I can't tell what you're trying to do. Maybe this:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 01-05-2016, 01:38 PM #5
    yogup
    yogup is offline
    Registered User
    Join Date
    12-16-2015
    Location
    Essex UK
    MS-Off Ver
    office 365
    Posts
    11

    Re: just a smidgeon of correction to VBA sort list code please

    thanks that works well apart from it copies the header row too unfortunately
    Reply With QuoteRegister To Reply
  6. 01-05-2016, 01:42 PM #6
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: just a smidgeon of correction to VBA sort list code please 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 01-05-2016, 01:46 PM #7
    yogup
    yogup is offline
    Registered User
    Join Date
    12-16-2015
    Location
    Essex UK
    MS-Off Ver
    office 365
    Posts
    11

    Re: just a smidgeon of correction to VBA sort list code please

    That's magic thanks. just getting my head around it all again and everyone has slightly different ways of coding
    Reply With QuoteRegister To Reply
  8. 01-05-2016, 01:48 PM #8
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: just a smidgeon of correction to VBA sort list code please

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] IF formula correction
    By mra1984 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-06-2013, 12:36 PM
  2. Formula correction
    By mukeshbaviskar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-17-2013, 04:08 AM
  3. VBA Code Correction
    By RichIT in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2006, 11:35 AM
  4. Code Correction Need
    By Safi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-30-2006, 01:10 PM
  5. correction
    By nowfal in forum Excel General
    Replies: 4
    Last Post: 03-24-2006, 02:40 PM
  6. [SOLVED] two arrays correction
    By Jerry Kinder in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-25-2006, 06:10 PM
  7. correction of formula please............
    By azmi in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1