View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Concatenate a selected Range?

Hi All...........
With a UDF or a macro, would it be possible to CONCATENATE all the cells in
a selected Range, say A1:a7 without having to type each cell
address.........something like =SpecialCONCATENATE(A1:A7), or
=SpecialCONCATENATE(MyRange), of course those don't work, but that's the
idea.

TIA
Vaya con Dios,
Chuck, CABGx3