Hi
I have a simple Vba code to combine data from two columns in two different sheets into another sheet. The problem is that only the first statement of code executes. Meaning it only copy and pastes data from the "Security" sheet. It seems I am missing some code to combine the two statements. I will appreciate if someone can helps. my code is:
I will appreciate if someone can help.
Please Login or Register to view this content.
Last edited by Chris*; 01-14-2014 at 08:00 AM.
Post a sample data set because the code works (as in it does not have an error) for me.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Hi MikeTRON
Please see attached file. Thanks for your help.
Problem had to do with range of data that was to be copied. Range seems like it cannot be the whole column. When I specified the range as only the cells where the data appears the macro worked. Instead of Range("A:A") I had to specify it it as Range("A2:A500"). Then it worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks