Excel VBA provide options on how to pass value from worksheet to worksheet or from workbook to another workbook.
To optimize or make the VBA code run faster is to make the worksheet interaction lesser.
Recording an Excel VBA macro to copy and paste a value will have a similar output to the code below.
' Macro1 Macro
what the code does is to select the cell on the active sheet for copying and select another worksheet and select the cell where the value will be placed and paste the copied cell value.
a. Select the cell and copy the value
b. Select the worksheet where the value is to be copied
c. Next step, is select the cell on the selected worksheet
d. Paste the value on the cell
Steps are absolutely fine, if it works as expected. But if you are copying hundreds or thousands of cells. It will be a waste of time and the computer will be very slow.
Another way to copy and paste a value, or reference a cell value is using the code below:
Code above uses copy and paste method, but ultimately waste clipboard memory.
Code below is quite optimized since the value is just reference to the cell and no clipboard memory resources are used, and selecting worksheet is not needed also.
Worksheets("Sheet3").Range("C1:C25").Resize.Value = Worksheets("Sheet1").Range("b1:b25").Resize.Value
Mileage will always vary, of course any code optimized or not optimized is good, as long as it deliver the expected results.
Hope it helps.
Linux Android App cheat sheet:
Cheers..till next time!
Free Android Apps:
links below to find out more:
Multiplication Table for early learners
Catholic Rosary Guide for Android:
Divine Mercy Chaplet Guide (A Powerful prayer):