Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

To use the Copy function and Paste method, first insert the formula in the original cell as before, execute the Copy function of the

Sub copy()     Cells(2, "B").copy     Range("B2:B10").Select     ActiveSheet.Paste End Sub