How to paste a cell value to the active cell
Requirement:
VBA code to Just copy A2 to active cell and move down one cell.
Solution:
Code:
With ActiveCell
.Value = [a2]
.Offset(1).Activate
End With
Obtained from the OzGrid Help Forum.
Solution provided by KjBox.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to paste value when creating a master summary sheet |
| How to copy the entire sheet and paste as values - running on multiple tabs |
| How to copy and paste column in wkbk 1 if its cell has text which matches with a cell of wbk 2 |
| How to copy the data from sheet 1 and paste the data to sheet 2 each first empty row of each row |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
