| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with VBA Macro to automatically copy/paste as Values
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 row 55 and 85 are less than 100 off. Is there a way to automate this process with either a function or a macro? Thanks in advance, Anand |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with macro to copy, paste, and clear cell values | Excel Discussion (Misc queries) | |||
| copy paste values macro | Excel Discussion (Misc queries) | |||
| Macro for copy and paste values | Excel Discussion (Misc queries) | |||
| copy-paste as Values automatically | Excel Worksheet Functions | |||
| Copy & Paste values macro...almost there? | Excel Programming | |||
Threaded Mode
