Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Assign the value in C1 in the active sheet to D10 in the sheet named Sales, in the active workbook

Sub valueDemo()      Worksheets("Sales").range("D10").value = range("C1").value End Sub