Greetings,
I am trying to copy columns based on an Array. I have the following code (this is just the part of the code I am having issues with) and it is not working.
![]()
Please Login or Register to view this content.
Greetings,
I am trying to copy columns based on an Array. I have the following code (this is just the part of the code I am having issues with) and it is not working.
![]()
Please Login or Register to view this content.
Mr. brentjohn,
Good morning sir. Just a quick question for you. Is this code throwing an error, or is it just not working the way it was meant to work??
Dome
BrokenDome,
I am getting an error. "Range of object_Global failed.
Are the values in AV12:AV14 the names of named ranges?
Or range addresses?
Fluff13,
They are the names of the columns.
Fluff13,
For ex: cell AV12 (ms_Rest_Column) is the name range for column A.
Mr. brentjohn,
To copy over columns you can use something much simpler like the following:
This will copy the three columns into your second sheet. Hope this helps!!![]()
Please Login or Register to view this content.
Dome
Last edited by BrokenDome; 06-05-2019 at 10:46 AM. Reason: Change info
Ok, how about![]()
Please Login or Register to view this content.
Do you actually have named ranges like 'ms_Rest_Column' or is that the column heading?
If posting code please use code tags, see here.
Norie,
Yes, these are named ranges, not column headings.
Have you tried what I suggested in post#8?
Fluff,
Sorry, I have been on conference calls and have not had an opportunity to incorporate your suggestion. I will shortly and let everyone know. Thank you for your help!!!
Fluff,
I am sorry for the late response, I have been on conference calls all day. Your code works great. However, I failed to state that within each of the columns are hidden rows. Your code actually copies the hidden rows and paste them.
Ok, how about![]()
Please Login or Register to view this content.
Fluff13,
Works perfectly!!! Thank you much for your patience!
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks