Can I autofill using a Variable Range?

I have a fairly large workbook with a lot of formulas. My spreadsheet involves pasting data into fields A2:K_(?) . The formulas are in AA:AK.

The "?" is because the data could be anywhere from 200 lines up to 8000 lines.

In an effort to reduce size (and memory on an old laptop), I would like to load the data in Columns A:K as usual, use COUNTA to determine how many lines of data there are, and then copy the formulas from AA2:AK2 into as many rows as needed.

I have created a cell to contain COUNTA (A2:A10000), and have created another cell to say "AA2:AK __(whatever the COUNTA is)__", but then when I try to use "RANGE" and "VALUE" in macro to pull the data from that cell, I get an error.

Is there a way to do this? Thanks in advance.

TMS,

Thank you for the prompt response. To my Rookie eye, it looks like you're actually entering a specific formula into each cell in J.

It's definitely a big help already, but if there are more formulas in columns K and L as well, do I need to do a seperate "FORMULA =" line for each column? I was hoping for generic macro that would copy the formula whatever it may be.

Sorry... Thanks!