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



"Madhu" <[email protected]> wrote in message
news:#[email protected]...
> What is the vba code for pasting a value in the active cell
> thanks
> Madhu
>
>

[Bob Phillips]

if doing the copy then you can just use

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

--
HTH

Bob Phillips

"Mangesh Yadav" <[email protected]> wrote in message
news:[email protected]...
> Range("A1").Copy
> ActiveCell.PasteSpecial
>
>
> Mangesh
>
>
>
> "Madhu" <[email protected]> wrote in message
> news:#[email protected]...
> > What is the vba code for pasting a value in the active cell
> > thanks
> > Madhu
> >
> >
>
>