Thnkyou Guys for the codes.
The code that Anoop sen t works very well, and I will go with that. Thanks
for your help Lalit and Anoop
Regards
Charlie
On Mon, Dec 31, 2012 at 7:45 PM, Anoop K Sharma wrote:
> Please try the below one.
>
> Sub PasteValueOnly()
> Dim rng As Range
> Set rng
Please try the below one.
Sub PasteValueOnly()
Dim rng As Range
Set rng = Sheets("DailyList").Range("ItemsList")
rng.Copy
Sheets("ItemsListArchives").Range("D1").PasteSpecial xlPasteValues
End Sub
On Mon, Dec 31, 2012 at 12:01 PM, Lalit Mohan Pandey <
mohan.pande...@gmail.com> w
Dear Charlie,
Please share your file with us if it is confidential then please share
sample at least for better clearity.
Regards,
Lalit Mohan
On Monday, 31 December 2012 11:46:32 UTC+5:30, sswcharlie wrote:
>
> Hi Lalit
>
> Have tried the code , same result. Getting the 'application define
Hi Lalit
Have tried the code , same result. Getting the 'application defined or
object defined error' message. Can you review for me. A mystery to solve.
Thnaks
Charlie
On Mon, Dec 31, 2012 at 4:11 PM, Lalit Mohan Pandey <
mohan.pande...@gmail.com> wrote:
> Hi Charlie,
>
> You can copy on