View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default Inserting a Comma in Many Cells

try this on your selection.

sub putcomma
for each c in selection
c.value = c & ","
next
end sub

--
Don Guillett
SalesAid Software

"Ken" wrote in message
m...
How can I insert a comma at the end of each entry in a long column of
e-mail addresses?