xlPasteAll in pastespecial function

[lezawang]

Hi I want to copy a cell then paste it somewhere. After review this website https://stackoverflow.com/questions/18968856/vba-paste-range I came with the code below.

My question, what does xlPasteAll means? and also can I just after copying a cell paste it into a cell that i will select with a mouse? Thank you so much

+++++++++

Sub copycell()
ThisWorkbook.Sheets(1).Cells(2, 2).Copy
End Sub


Sub pastecell()
Cells(1, 1).PasteSpecial xlPasteAll
End Sub

 

[MARK858]

https://docs.microsoft.com/en-us/do...lpastetype?redirectedfrom=MSDN&view=excel-pia

 

[lezawang]

great, thank you so much.