What is the vba code for pasting a value in the active cell thanks Madhu
B Bob Phillips Jun 2, 2005 #3 if doing the copy then you can just use Activecell.Value = range("A1").Value
