+ Reply to Thread
Results 1 to 2 of 2

Sub copied from one workbook to second not working

  1. #1
    Registered User
    Join Date
    01-12-2012
    Location
    Rockland, WI
    MS-Off Ver
    Excel 2016
    Posts
    56

    Sub copied from one workbook to second not working

    I have a subroutine "GetLastMaintenance" that I developed after several iterations in Workbook "Last Maint Test", but does not work when I copy it back to my original workbook "Last Maint Live" from which it was developed. I renamed one sheet "maintenance" to "allmaintenance", (adjusting accordingly) and cannot think of any other changes I made. I assume I'm missing something relatively obvious, but am very new to VBA.

    Can someone point me in the right direction?

    Both files attached.

    Please Login or Register  to view this content.

    Thanks
    Attached Files Attached Files
    Last edited by jdfjab; 02-07-2012 at 07:25 AM.

  2. #2
    Registered User
    Join Date
    01-12-2012
    Location
    Rockland, WI
    MS-Off Ver
    Excel 2016
    Posts
    56

    Re: Sub copied from one workbook to second not working

    Thanks for all the views. I found my error. I had forgotten to build "skeys" into the maintenance table in the original workbook.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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