Write Single Lines Code Following Set Value Cell A17 Sales Sheet Active Workbook 1325 Capt Q37142690

7. Write single lines of code for each of the following.

   1. Set the value of cell A17 in the Sales sheet of the activeworkbook to 1325.

   2. Capture the value of cell B25 in the Quantities sheet of theworkbook

      Sales.xlsx in the variable marchSales.

   3. Clear the contents of the range named Sales.

   4. Copy the range A1:A10 on the Sheet1 worksheet of the activeworkbook to

      the range A1:A10 of the MarchSales sheet in the Sales.xlsxworkbook. Assume that Sales.xlsx is not the active workbook.

Solution