justlearning4
New Member
- Joined
- Nov 17, 2022
- Messages
- 25
- Office Version
- 365
- Platform
- Windows
Hello,
This is my first time posting, so I hope it goes well. I am having an issue with developing a VBA code that transfers all data from the 'Insert CDRN Data" sheet to exact columns in the 'Calendar' sheet. Every time I run the code, I get an error message that says "Subscript out of range" which is odd because the sheets I am referencing all exist, which you can see in the attachments. I would greatly appreciate if someone could help me with this as I am in the first week of learning how to code with VBA.
*For reference, the Subs below "MoveDates" work, but I am trying to develop a code that copies and pastes all data that is shown in the "Insert CDRN Data".
Thank you!
This is my first time posting, so I hope it goes well. I am having an issue with developing a VBA code that transfers all data from the 'Insert CDRN Data" sheet to exact columns in the 'Calendar' sheet. Every time I run the code, I get an error message that says "Subscript out of range" which is odd because the sheets I am referencing all exist, which you can see in the attachments. I would greatly appreciate if someone could help me with this as I am in the first week of learning how to code with VBA.
*For reference, the Subs below "MoveDates" work, but I am trying to develop a code that copies and pastes all data that is shown in the "Insert CDRN Data".
Thank you!