| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
copy-paste as Values automatically
I have a worksheet with an inherent circular calculation. To get the answers
to converge, I need to copy D85:W85 to row 55 as Values and hit shift+F9. I keep doing this (about 5-6 times) till the numbers in D86:W86 are less than say 100. Is there a way to automate this process with either a function or a macro? Thanks in advance, Anand |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy & Paste macro | Excel Worksheet Functions | |||
| copy paste | Excel Discussion (Misc queries) | |||
| Copy Paste Special Macro | Excel Discussion (Misc queries) | |||
| paste special | values should work with merged cells | Excel Discussion (Misc queries) | |||
| copy exact values from RangeA to Range B which has extra rows | Excel Discussion (Misc queries) | |||
Linear Mode
