Copying a calculations answer and not the calculation
 

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.


--
kirby_t07
------------------------------------------------------------------------
kirby_t07's Profile: http://www.excelforum.com/member.php...o&userid=32835
View this thread: http://www.excelforum.com/showthread...hreadid=526324

Copying a calculations answer and not the calculation
 

kirby, you could use something like this,

Sheet2.Range("B1:B20").Value = Sheet1.Range("A1:A20").Value


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"kirby_t07" wrote
in message ...

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.


--
kirby_t07
------------------------------------------------------------------------
kirby_t07's Profile:
http://www.excelforum.com/member.php...o&userid=32835
View this thread: http://www.excelforum.com/showthread...hreadid=526324