Concatenation with double quotes and comma for the selected list of values

Hi,I have a list of values i.e.CPARTY_ID_STATUS GL_GROUPING_CD_OLD_STATUS GL_GROUPING_CD_STATUS GL_GRPING_OVERRIDE_STATUS I'm trying to concatenate them like below"CPARTY_ID_STATUS",""GL_GROUPING_CD_OLD_STATUS",""GL_GROUPING_CD_STATUS","" GL_GRPING_OVERRIDE_STATUS"But no luck with the below vba, request forum experts advise!Set lookupRng = Application.InputBox("Lookup Values", "Select Lookup Values", Type:=8)MsgBox "The cells selected were " & lookupRng.AddressFor Each cell In... Read the entire article at the source link... chakkrav

http://codango.com/concatenation-with-double-quotes-and-comma-for-the-selected-list-of-values/

I am happy to share this resource that we found. The content displayed on this page is property of its original author or their organization.