A userform was designed to compile a template list of project names into a dropdown combobox. When the type of project is selected the code needs to copy the Templates (sheet's codename) range into the Gantt (sheet's codename) next available row. I expect the user to change the name of the sheet so copying and pasting with codenames is more ideal. I can't seem to get this to function the way I am coding it.
This example works but seems limited to the absolute range references to me:
The way I'm attempting to code this is something like the following which tries to turn the range into a string for insertion into the above format:
This looks messy but I can't seem to hunt down a good way to work with dynamic codename references. Any thoughts on this problem?
Kind regards,
LinkBack URL
About LinkBacks
Register To Reply
icon below to give reputation feedback, it is appreciated.
below the post.
Bookmarks