Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a formulas answers and not its calculation in VBA
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=526323 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a formulas answers and not its calculation in VBA
Please mail ) your workbook with text
explaining expected results I hope I can help -- AP "kirby_t07" a écrit dans le message de ... 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=526323 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a formulas answers and not its calculation in VBA
There's an option in Excel to paste values only (or other things):
Edit/Paste Special/Values You can emulate this in VBA with TargetRange.PasteSpecial XlPasteType:=xlPasteValues kirby_t07 wrote: 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=526323 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a formulas answers and not its calculation in VBA
Have sent the email, apologize for taking so long, wasn't aware anyone had replied . Hope you can help! -- kirby_t07 ------------------------------------------------------------------------ kirby_t07's Profile: http://www.excelforum.com/member.php...o&userid=32835 View this thread: http://www.excelforum.com/showthread...hreadid=526323 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a formulas answers and not its calculation in VBA
Here's your workbook with a few modifications: http://cjoint.com/?dCokqBCQwv
I felt free to revise the syntax of your macros to make them clearer and more concise. HTH -- AP "kirby_t07" a écrit dans le message de ... Have sent the email, apologize for taking so long, wasn't aware anyone had replied . Hope you can help! -- kirby_t07 ------------------------------------------------------------------------ kirby_t07's Profile: http://www.excelforum.com/member.php...o&userid=32835 View this thread: http://www.excelforum.com/showthread...hreadid=526323 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COPYING THE ANSWERS TO NOTEPAD / WORD | Excel Discussion (Misc queries) | |||
FORMULAS THAT CAN HAVE DIFFERENT ANSWERS DEPENDING ON DATA INPUT | Excel Worksheet Functions | |||
print excel with formulas and answers together | Excel Discussion (Misc queries) | |||
help. Excel shows formulas, not answers | Excel Worksheet Functions | |||
When I change my data, my formulas don't update the answers,why? | Excel Discussion (Misc queries) |