View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Grumpy Grumpy is offline
external usenet poster
 
Posts: 1
Default Macro to concatenate previously selected cells

Hello, everyone!

I'm trying to write a macro that would allow me to concatenate the
contents of several already selected (but not adjacent) cells into one
cell. In other words, I want to be able to go to a worksheet, select
several different cells by using the Ctrl key and then run the macro to
concatenate what is in those cells into one cell, preferably the upper
leftmost cell of the ones selected.

Any help on this would be greatly appreciate.

My first post, so don't chastise me too much if what I'm asking has a
simple solution.

Thanks,