+ Reply to Thread
Results 1 to 9 of 9

DeBug error

Hybrid View

  1. #1
    Registered User
    Join Date
    08-22-2018
    Location
    Grand Rapids, MI
    MS-Off Ver
    2010
    Posts
    5

    Thumbs up Re: DeBug error

    Awesome! 1 more thing, in the field where it states where to pull the info from for the file name, is there a way to pull additional information in different cells and have that placed in the name as well. For instance, the date and time of the call as well as the name of the agent. So currently D9 is the name of the agent, but in G13 and H13 are the date and time of the call. Is that possible to add to the formula?


    filename1 = Sheets("TP QA Form").Range("D9").Text

    I tried adding it like this and it did not work:


    filename1 = Sheets("TP QA Form").Range("D9", "G13", "H13").Text
    Suggestions? Can it be done?
    Last edited by dominicb; 08-23-2018 at 03:34 PM.

+ 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. debug error
    By speedstr in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-19-2018, 07:08 PM
  2. Debug Error
    By cartica in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-09-2015, 09:23 PM
  3. VBA Code Runs in Debug Mode But Returns Type Mismatch Error Outside Debug Mode
    By valerie.k.chiang in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2014, 03:48 PM
  4. debug error
    By VBisgreat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-21-2012, 02:12 PM
  5. if Then = debug error
    By garretonufer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-23-2009, 04:00 PM
  6. Debug error 13
    By BillGoodman in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 06-23-2009, 03:12 PM
  7. Error Won't Debug
    By Trip in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-29-2006, 03:10 PM

Tags for this Thread

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