Complicated Project
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Complicated Project

  1. #11
    New Member
    Join Date
    Aug 2019
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Complicated Project

    Quote Originally Posted by VBAnewbie7 View Post
    Alright, i created a whole new module and typed it out myself and it works now, mostly.

    It does the job but then at the very end it creates an "extra" sheet and then hits an error on this line:

    Sheets.Add(after:=Sheets(Sheets.Count)).Name = Ar(x)

    It is the more typical error of "Run-time error 1004. Application-defined or object-defined error"
    This honestly isnt a huge deal as i can just delete the extra sheet but it would be great if it's an easy fix
    Fixed this by placing "On Error Resume Next" before the line the error was happening on.

    Thank you everyone for your help!! This is going to save me so much time and headache!

  2. #12
    Board Regular
    Join Date
    Oct 2007
    Location
    Kuwait
    Posts
    449
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Complicated Project

    Glad we could help & thanks for the feedback

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
  •