I have 22 different files for which I want to use the same procedure (with
few modifications). The procedure opens a specific file (different for each
file containing the macro), inserts columns, inserts formulas, and then fills
the formulas down to the last cell in it's column. (Maunally I would simply
double-click the autofill handle and Excel would copy down to the last cell
based on the column to the left.) When I record the actions, the ending cell
is absolute, so I've had to go into each of the 22 modules and manually enter
the ending cells for each file. I know there's a way to set the last cell I
need as a variable, but even after reading other posts on this subject I
can't get it to work.

Thanks to all for your suggestions.
--
TIA, Nan