"Doc60" wrote:
> Unfortunately I have already written two seperate macros due to the number of
> other calculations that take place in the two different tables. So how would
> I designate the different tables in the macro. So that when I run the second
> macro for the second table it will not revert to the first table?
>
Look at my code. The first thing I do is identify the current table index so
that I know which Nth table I am dealing with.
Do the same at the top of each of your macros, or have a central macro that
will identify the table index, and then call the appropriate sub-macro once
the table index has been identified.
Also, see how I use a table object, make sure you do that, this way you
always know which table you are dealing with within the code.