VBA help for newbie - Page 6

Page 6 of 6 FirstFirst ... 456
Results 51 to 54 of 54

Thread: VBA help for newbie

  1. #51
    Board Regular
    Join Date
    Jun 2017
    Location
    Nth Vic, Australia
    Posts
    589
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    3 Thread(s)

    Default Re: VBA help for newbie

     
    Hmm. I'm not sure what I did. Maybe I'm just a little too close for the moment. I've just adopted your Sen1>Sen2 without further edits and those two instances that I cited above are not apparent.

    Let's hope that all the bugs are rid.
    Last edited by BrianJN1; Nov 30th, 2017 at 01:19 AM.
    You may see and know but until you tell me exactly I am blind; I cannot read your mind.
    Attachments? No, but check for on site preferences.
    Cloud sharing or other off-site links? Yes, but off-site links are fragile into the future.

  2. #52
    Board Regular
    Join Date
    Jun 2017
    Location
    Nth Vic, Australia
    Posts
    589
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    3 Thread(s)

    Default Re: VBA help for newbie

    Ok Pete. I've gone back and "deskchecked" the data which concurs with the following table.
    Do you also concur that is where you arrived? If so we can both say that your project is ready.

    Excel 2013/2016
    ABCDEFGHIJKLMNOP
    1PR1App?PR2App?PR3App?PR4App?SenAge
    2NameStEndStEndStEndStEnd
    3Jones3-Jan-1812-Jan-18No6-May-1814-May-18No4-Apr-1814-Apr-18No18-Feb-1828-Feb-18Yes3-Jun-1735
    4Smith13-May-1825-May-18Yes10-Nov-1820-Nov-18Yes7-Jun-1817-Jun-18Yes17-Jan-1831-Jan-18No2-Jun-1730
    5Chan2-Jan-183-Jan-18Yes5-Dec-1812-Dec-18Yes13-Aug-1823-Aug-18Yes20-Jun-1830-Jun-18Yes1-Jun-1740
    6Wills12-Jan-1823-Jan-18Yes2-Jul-1818-Jul-18Yes5-Oct-1815-Oct-18No19-Sep-1829-Sep-18Yes4-Jun-1741
    7Thom6-Feb-1813-Feb-18Yes1-Mar-1811-Mar-18No4-Jul-1814-Jul-18No27-Dec-186-Jan-19Yes5-Jun-1742
    8Ford3-Mar-1817-Mar-18Yes3-Apr-1810-Apr-18No15-Jan-1825-Jan-18No4-Apr-1814-Apr-18No6-Jun-1744
    9Simons8-Mar-1815-Mar-18No4-Mar-1814-Mar-18No6-Sep-1816-Sep-18Yes6-Aug-1816-Aug-18No7-Jun-1743
    10Dean9-Apr-1816-Apr-18No9-Oct-1819-Oct-18Yes2-Feb-1812-Feb-18No21-Oct-1831-Oct-18Yes9-Jun-1745
    11George15-Apr-1828-Apr-18Yes3-May-1811-May-18Yes7-May-1817-May-18No21-Nov-181-Dec-18Yes8-Jun-1746

    Sheet1



    You may see and know but until you tell me exactly I am blind; I cannot read your mind.
    Attachments? No, but check for on site preferences.
    Cloud sharing or other off-site links? Yes, but off-site links are fragile into the future.

  3. #53
    Board Regular
    Join Date
    Jan 2010
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA help for newbie

    Hi Brian,

    I definitely concur with the data above, and after the small mod I made, I believe it is definitely ready for service. I plan to add a few features with my newly acquired, albeit basic, knowledge of VBA. Thank you again for taking the time to help with the project, and with helping a newbie get hold of the basics.

    Pete

  4. #54
    Board Regular
    Join Date
    Jun 2017
    Location
    Nth Vic, Australia
    Posts
    589
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    3 Thread(s)

    Default Re: VBA help for newbie

      
    Your welcome.
    You may see and know but until you tell me exactly I am blind; I cannot read your mind.
    Attachments? No, but check for on site preferences.
    Cloud sharing or other off-site links? Yes, but off-site links are fragile into the future.

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
  •  

 

 
DMCA.com