billandrew
Well-known Member
- Joined
- Mar 9, 2014
- Messages
- 743
Seems so simple not sure what I am doing here
trying to copy used range in Book4 to Book5 or entire sheet..
Sheets("Sheet1").UsedRange.Copy Workbooks("Book5.xlsx").Sheets("Sheet1")
trying to copy used range in Book4 to Book5 or entire sheet..
Sheets("Sheet1").UsedRange.Copy Workbooks("Book5.xlsx").Sheets("Sheet1")