View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] koperstexdq_dont_use@gmail.com is offline
external usenet poster
 
Posts: 28
Default Copy one cell and merge into another

Hi,

Is a macro for this possible?

1. Active cell (is a number)
2. 4 cells to the right from active cell (is text)
3. Add the value from the first cell (1) at the end of the text without any
space


Example

Before macro:
First active cell = any number e.g. 458
Four cells to the right = Test/

After macro:
First active cell = 458
Four cells to the right = Test/458 (if possible change 458 to blue colour.

Kaj Pedersen