I am trying to write a macro that copies specific columns and then inserts them into the next available column. This is what I currently have
I'm getting selection not valid, I believe it's because its not selecting the entire column which i want it to do. Any suggestions? Thanks for the help.
Please Login or Register to view this content.
your code works on my excel 2010, but you can change so:
otherwise attach a sample filePlease Login or Register to view this content.
Last edited by patel45; 05-31-2013 at 02:24 AM.
If solved remember to mark Thread as solved
column example.xlsm I couldn't send the exact file because it includes sensitive information but here is something similar to what I am working on, the macro kinda works in this example but its not in the one I'm working in. The macro copies the columns just fine but then fails when it tries to insert, i believe it has to do with the factselects a cell and not an entire column. is there a way to select the entire next available column and then insert the copied columns there?Please Login or Register to view this content.
If the macro works in the example but not in the original attach the original with sensitive data changed
Not sure why but now it's working, I didn't change a thing, Thanks for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks