Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Program to record where you've been?
I'm struggling a bit with a macro I'm writing that has several layers of
loops and IF statements and calls to subs. I'll figure out what the problem is, given a little time, but I was wondering if there is software out there that would act like a recorder and record each line in the order it was exectuted. I think this would help immensely in what I'm trying to do. Does anyone know of such a tool? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Program to record where you've been?
Not sure if you are talking about something completely beyond this level, but
have you tried walking through the code using F8? "salgud" wrote: I'm struggling a bit with a macro I'm writing that has several layers of loops and IF statements and calls to subs. I'll figure out what the problem is, given a little time, but I was wondering if there is software out there that would act like a recorder and record each line in the order it was exectuted. I think this would help immensely in what I'm trying to do. Does anyone know of such a tool? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Program to record where you've been?
On Thu, 7 Aug 2008 15:04:10 -0700, akphidelt wrote:
Not sure if you are talking about something completely beyond this level, but have you tried walking through the code using F8? Thanks for your reply. Yes, I have, and I figured out the problem. It just occured to me that if I had such a tool, I could have figured out the problem by stepping through once, rather than 3 or 4 times. A line by line record would have shown me I was resetting a variable twice instead of once right away. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open new record with selected fields from previous record | Excel Discussion (Misc queries) | |||
Record macro doesn't record shape properties | Excel Programming | |||
Program Column B to record numerical range based on number in colm | Excel Discussion (Misc queries) | |||
Finding last record in month for each of several types of record. | Excel Programming | |||
Record Macro - Record custom user actions | Excel Programming |