LinkBack URL
About LinkBacks
Hello,
I need a macro that takes the selected cells values in a column and makes a single cell with comma separated values
example
45
48
50
55
60
Should look like this:
45, 48, 50, 55, 60
If anyone can help me i would be very happy!
/m
Hello,
I need a macro that takes the selected cells values in a column and makes a single cell with comma separated values
example
45
48
50
55
60
Should look like this:
45, 48, 50, 55, 60
If anyone can help me i would be very happy!
/m
Please Login or Register to view this content.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Or
Please Login or Register to view this content.
Thanks both of you for really quick answer.
Is there a way to get the result of the script in the top cell of the selected range?
EDIT: the vba script does not seem to work like intended. I select cells, but it generates values from other places in the sheet
Last edited by mossman; 12-20-2009 at 10:37 AM.
Somelike this would do it. Not sure about where the data may reside initially. That would help determine where to position the rows and columns.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks