Hi,
I think you should use "F8" button to see what happens at each step.
Akhilesh
On Tue, Sep 2, 2008 at 10:50 PM, c-class <[EMAIL PROTECTED]>wrote:
>
> Hello,
>
> I have the following problem:
>
> Workbooks(datei).Sheets(land).Activate
>
> Range("A1:Z176").Copy
>
> Workbooks(hier).Activate
> Sheets(land).Activate
> ActiveSheet.Paste
>
> Workbooks(datei).Activate
> ActiveWorkbook.Close
>
> This code should open a workbook (datei) and within in the sheet
> (land) to copy the area from A1 to Z176 into the workbook (hier) and
> within this into the sheet (land).
>
> But my script is copying anything (don't know what). Can you a
> structual problem here or anything?
> Thanks
> Nico
>
> >
>
--
Akhilesh Kumar Karna
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to [email protected]
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
