Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy destination
This does just what I want:
Sub TestTransfer() Sheets("Pages").Cells(10, 5).Copy Destination:=Sheets("Schedule").Cells(5, 2) Sheets("Pages").Cells(10, 3).Copy Destination:=Sheets("Schedule").Cells(5, 3) End Sub except it copies across the formatting and well as the contents. I want contents only copied across. Please - thanks. Francis Hookham |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy destination
Hi Francis,
Try something like: '============= PublicSub TestTransfer() With Sheets("Schedule") .Cells(5, 2).Value = Sheets("Pages").Cells(10, 5).Value .Cells(5, 3).Value = Sheets("Pages").Cells(10, 3).Value End With End Sub '<<============= --- Regards, Norman "Francis Hookham" wrote in message ... This does just what I want: Sub TestTransfer() Sheets("Pages").Cells(10, 5).Copy Destination:=Sheets("Schedule").Cells(5, 2) Sheets("Pages").Cells(10, 3).Copy Destination:=Sheets("Schedule").Cells(5, 3) End Sub except it copies across the formatting and well as the contents. I want contents only copied across. Please - thanks. Francis Hookham |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy destination
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy destination
Hi Don,
Ranges must be the same size. Perhaps, in the context of my code, you could expand your comments? By the way, did you try the code? --- Regards, Norman |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy destination
Hi Francis,
A slight typo! Replace: PublicSub TestTransfer() with Public Sub TestTransfer() --- Regards, Norman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with copy destination | Excel Programming | |||
VBA .copy destination | Excel Discussion (Misc queries) | |||
Copy destination problem | Excel Programming | |||
copy destination values | Excel Programming | |||
.Copy Destination:= .PasteSpecial ??? | Excel Programming |