vba query

[Madhu]

What is the vba code for pasting a value in the active cell
thanks
Madhu

 

[Mangesh Yadav]

Range("A1").Copy
ActiveCell.PasteSpecial


Mangesh

 

[Bob Phillips]

if doing the copy then you can just use

Activecell.Value = range("A1").Value