Johnny C
Well-known Member
- Joined
- Nov 7, 2006
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Here's the code. There's 2 workbooks, the intention is to copy from one to the other. Both workbook names are strings. Both files have worksheets codenamed wksSourceData/wksTargetData (it doesn't make any odds if I change them).
But I'm getting 'Objest doesn't support this property or method' on either of the select statements (oddly sometimes it's the forst sometimes it's the second)
I've been using this code for years, what am I doing wrong? I think I'm going senile
But I'm getting 'Objest doesn't support this property or method' on either of the select statements (oddly sometimes it's the forst sometimes it's the second)
I've been using this code for years, what am I doing wrong? I think I'm going senile
VBA Code:
Workbooks(ThisFile).Activate
ActiveWorkbook.wksSourceData.Range("A5:A2000").Select
Selection.Copy
Workbooks(CopyFile).Activate
ActiveWorkbook.wksTargetData.Range("N4").Select