I am knew to Macros, and I'm trying to create macro that will
calculate a table full of formulas (each cell has a different formula
and each row has a different variable). Each row has a variable
relating to the formulas for that row. The spreadsheet is very large
with lots of calculations. I know how to change my variable cells. I
just do not know how to recalculate my table (using all the
calculations throughout the spreadsheet) with each row having a
different variable. Example:
Variable for row 1 = 4, row 2 = 5, and row 3 = 6. Formulas for the
different columns would be like this: Column A = cellref/var(row1),
Column B = 2*cellref/var(row1), Column C = cellref*cellref/
var(row1). (Other rows have same formula with different row
variable). If anyone can help I'd appreciate it.

Thanks.