What is the vba code for pasting a value in the active cell
thanks
Madhu
What is the vba code for pasting a value in the active cell
thanks
Madhu
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
>
>
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
> >
> >
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks