Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I try to use the script you help me with to copy pictures from one sheet to another this one: Sub testme() Dim FWks As Worksheet Dim TWks As Worksheet Dim myPict As Picture Set FWks = Worksheets("billeder") Set TWks = Worksheets("print") For Each myPict In FWks.Pictures myPict.copy TWks.Range(myPict.TopLeftCell.Address(0, 0)).PasteSpecial _ Paste:=xlPasteAll Next myPict End Sub But get an error by excel there write "excel canoot paste the data" CAn you or someone else help me? regards Alvin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dave Peterson...HELP!!!! | Excel Discussion (Misc queries) | |||
Dave Peterson | Excel Worksheet Functions | |||
Dave Peterson | Excel Discussion (Misc queries) | |||
Dave Peterson | Excel Discussion (Misc queries) | |||
Dave Peterson | Excel Discussion (Misc queries) |