I am creating a spreadsheet using matrices that allows you to add
pre-defined transformations to a triangle. I have a problem with
circular references because my macros have to copy and paste a lot of
calculations. for example the 'current coordinates of image' is a
formula mixing the original coordinates of the image with the current
matrix. Unfortunately this means that if i try and add more than one
transformation (which means the current cooridnates must be copied to
the original coordinates) i get the current coordinates trying to
divide by themselves.

Essentially what i need is a way of making the spreadsheet only copy
the answer to the formula not the calculation. I dont need it to be
live updated. is there a way of achieving this? I am new to excel and
VBA and am creating this spreadsheet for a school project. I can email,
post screenshots and provide more information if anyone can help me in
the slightest, i hope it is somethign obvious that im just missing.
Thanking you in advance.