Hello,
I am totaly new to VBA and guess I need to write a code for the problem.
I have two columns, say A and B. I need to copy value (text) from A only if B is active. The copy from all "active" cells in A shall be pasted in another cell on the same Sheet as a sequence, with ";" or "," between values.
So I was thinking something like this
etc...
Please Login or Register to view this content.
I hope some of you understand what you mean.
Many Thanks!
Last edited by arlu1201; 05-21-2013 at 03:59 AM.
Now I figured it out. Problem is solved. I am sure it is possible to write a shorter code, but I am happy with the one that works.
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks