View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Josh[_8_] Josh[_8_] is offline
external usenet poster
 
Posts: 2
Default Retain cell format while linking cells

I need some help here. I would like to link some cells together. Some
cells contain text, others contain currency. For Example:

A1 A2 A3
You owe me $10,000.00 Dollars!

I would like this to happen:

A5
You owe me $10,000.00 Dollars!


Linking cells doesn't work, I have read all over that it can be done
with VB. Except, there is no examples of what code would do this. I
would like help writing this simple (not for me) scenario, I could
make it work for what I need after that.

Thanks,
Josh