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
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
