View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lynette Olivier Lynette Olivier is offline
external usenet poster
 
Posts: 1
Default Excell VBA Macro with Symbols

I need to take data out of column A and put that with all commas but i
need to add the following symbol ', example

11111
11112
11113
11114

I need to create a macro that takes this column and create it as follows
11111,11112,11113,11114

but i need the symbol added so that it looks as follows:
'11111','11112','11113','11114'

*** Sent via Developersdex http://www.developersdex.com ***