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.