View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maarkr Maarkr is offline
external usenet poster
 
Posts: 20
Default append all instead of one

I've got this code to append cell data to the right of the selected cell

ActiveCell.Value = ActiveCell.Value & " " & ActiveCell.Offset(0, 1).Value

THis code only works for a single selected cell... not multiple cells.
I want to be able to select the entire column A (not just a single cell in
col a) or multiple cells and have all cells in B append into A.

thanks