Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
visual basic command to special paste a row of formulas into value
I am currently using this macro to copy a row of values from one sheet to
another using vsual basic editor strFrom = "[Data Source - Football]Source Prior Year Statistics!" strTo = "[Data Source - Football]Source Prior Year +1 Statistics!" CopyRangeAdd enumRange, strFrom & "J16:U21", strTo & "J16:U21" Currently this macro is copying values in one sheet to a value in another sheet I would now like to copy formulas in one sheet to values in another sheet |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help me please understand this Visual Basic command | Excel Discussion (Misc queries) | |||
What is the Visual Basic command to select an entire row in Excel. | Excel Programming | |||
What is the Visual Basic command to select an entire row in Excel. | Excel Programming | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming | |||
visual basic command in a cell?? | Excel Programming |