Hi,
I'm trying to create a macro that loops through all files in a folder.
During the loop I would like to use a for each statement:
For Each workbook in folder
- select the range("A10:AE" & Rows.Count).End(xlUP).Count
- Copy the range
- avoid the clipboard (using Destination:= WorkbookName)
- Paste to the workbook that contains the macro Range("A:A" & Rows.Count).End(xlup).count
- close workbook
Next Workbook
So far my code allows me to select a specified folder but does not execute the loop properly (no data gets copied and pasted)
Any help would be greatly appreciated, thank you.
Please Login or Register to view this content.
Bookmarks