+ Reply to Thread
Results 1 to 4 of 4

Tasks in Macro not working

  1. #1
    Registered User
    Join Date
    05-22-2019
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    66

    Tasks in Macro not working

    Can someone help me why Tasks 17 and 18 in the macro below not working?

    Please Login or Register  to view this content.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    Re: Tasks in Macro not working

    What do you want tasks 17 and 18 to do?

    What do they do instead?

    Without being able to see your file the comments are of limited use:

    Please Login or Register  to view this content.
    Does "corresponding cells" mean "the same row"?

    Where do you want to copy the data to?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    05-22-2019
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    66

    Re: Tasks in Macro not working

    Tasks 17 & 18 are supposed to do the same thing (different ranges). Copy/paste data from sheet “calculations2” to sheet “ToSS”. Both sheets are in the same workbook.

    Currently, all the macro works perfectly, but tasks 17/18 do not copy/paste anything.

    Yes, corresponding meaning the same row

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    Re: Tasks in Macro not working

    It is not possible to test your code without your file and your data. Please consider attaching a file.

    If I were getting no results I would check the values of the following variables using debug during execution.
    Please Login or Register  to view this content.

+ 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. Replies: 1
    Last Post: 10-05-2022, 02:12 AM
  2. Replies: 4
    Last Post: 06-26-2021, 09:02 AM
  3. [SOLVED] Lookup tasks and sort by date and exclude completed tasks
    By AlexSchmidt in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 10-19-2017, 04:47 PM
  4. Calculate working days between two dates for multiple tasks
    By Quasar82 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-24-2016, 02:31 PM
  5. [SOLVED] How to calculate average total working days for tasks completion
    By Laras in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-19-2013, 06:38 AM
  6. Outlook Tasks - Adding tasks from a worksheet added today or after
    By dpotta in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-28-2010, 07:15 AM
  7. Cell not working with 2 tasks
    By Rjc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2008, 02:43 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