View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 5
Default Combining Two Cells.

Hi ...

Some months ago I posted a question here, and someone was kind enough to
show me how to write the code to do what I needed. Unfortunately, I'm not a
good student and need a refresher.

Now, I know it's easy to combine two cells into one if you know what they
are, but what I have in mind is combining two cells on the fly, so to speak.

A1 ---------- B1
_____________
Company --- Bud's

I want to combine them so cell BI reads, `Bud's Company,' and cell A1 is
empty. I want the user to be able to do this operation easily, maybe just
pressing a `hot key' (CTRL-M, say) to accomplish it.

I have tried to reconstruct the code that some from this newsgroup did for
me, but I can't quite get it to work.

Appreciate any help.

Sam