+ Reply to Thread
Results 1 to 5 of 5

quick way to view the contents of a string after i run the macro

  1. #1
    Registered User
    Join Date
    08-03-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    21

    Cool quick way to view the contents of a string after i run the macro

    for some reason i am only adding 1 day at a time and the range i put in B43 is 6/12/2012
    to basically trigger the scenorio do your job part since it is over 30 days

    plus if just before i end sub I make the value of B43 become todaysdate, in my mind it will get thru all the errors and run the calculations first then change the value of B43 correct

    Please Login or Register  to view this content.
    plus in Excel 2003 is there a way to insert a command button to run the macro, or do i have to Alt-f8 run it all the time?

    I just want to see what i am coming up with in the values of DaysNumber, EnteredDate, TodaysDate
    for troubleshooting.
    this is code that came from the generosity of Pichingualas

    thanks for the help


    daluv

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: quick way to view the contents of a string after i run the macro

    Duplicate post http://www.excelforum.com/excel-prog...the-macro.html

  3. #3
    Registered User
    Join Date
    08-03-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    21

    Re: quick way to view the contents of a string after i run the macro

    I clicked that link and just set solved on that one. i couldnt find a way to delete it. thanks


  4. #4
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: quick way to view the contents of a string after i run the macro

    The other thread has been closed.

  5. #5
    Registered User
    Join Date
    08-03-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    21

    Re: quick way to view the contents of a string after i run the macro

    anyone have any thoughts on my solution?

    daluv

+ 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